CSC314-8 2014: Data Management Systems

Section outline

• Select section General

  General

  Collapse all Expand all

  • Select activity News forum

    

    News forum
  • Select activity CSC314-8 Database Management Systems syllabus

    

    CSC314-8 Database Management Systems syllabus File
  • Select activity Ideas for topics for your projects

    

    Ideas for topics for your projects Page
  • Select activity Projects Forum

    

    Projects Forum
  • Select activity Database manager interview forum

    

    Database manager interview forum
  • Select activity Grading cutoffs for our course

    

    Grading cutoffs for our course Page
  • Select activity News relevant to our course

    

    News relevant to our course Page
  • Select activity Forum for HW questions

    

    Forum for HW questions
• Select section Week 1

  Week 1

  • Select activity Monday, April 13

    Monday, April 13

  • Select activity Stanford Database course video

    

    Stanford Database course video URL
  • Select activity Tuesday video assignment

    

    Tuesday video assignment URL
  • Select activity COBOL

    

    COBOL URL

    Results of a survey related to COBOL.

  • Select activity Rudimentary Access 2013 "Workbench" tutorial part 1

    

    Rudimentary Access 2013 "Workbench" tutorial part 1 File
  • Select activity Rudimentary Access 2013 "Workbench" tutorial part 2

    

    Rudimentary Access 2013 "Workbench" tutorial part 2 File
  • Select activity Rudimentary Access 2013 "Workbench" tutorial last part

    

    Rudimentary Access 2013 "Workbench" tutorial last part File
  • Select activity Rudimentary Access 2010 "Workbench" tutorial part 1

    

    Rudimentary Access 2010 "Workbench" tutorial part 1 File
  • Select activity Rudimentary Access 2010 "Workbench" tutorial part 2

    

    Rudimentary Access 2010 "Workbench" tutorial part 2 File
  • Select activity Rudimentary Access 2010 "Workbench" tutorial last part

    

    Rudimentary Access 2010 "Workbench" tutorial last part File
  • Select activity Kroenke HW for Tuesday

    

    Kroenke HW for Tuesday Page
  • Select activity Tuesday, April 14

    Tuesday, April 14

  • Select activity Tuesday Stanford video

    

    Tuesday Stanford video URL
  • Select activity Stanford Relational Algebra video

    

    Stanford Relational Algebra video URL
  • Select activity Rosen assignment

    

    Rosen assignment File

    Read section 9.2 of Rosen (quickly) and hand in problems 10, 14, 18, 19, 28 from section 9.2. Due Thursday at 9.

  • Select activity E. F. Codd's paper

    

    E. F. Codd's paper File

    A Relational Model of Data for Large Shared Data Banks

  • Select activity Reading and HW Assignment for Wednesday and Thursday

    

    Reading and HW Assignment for Wednesday and Thursday Page
  • Select activity Wednesday, April 15

    Wednesday, April 15

  • Select activity Wednesday Access 2010 Lab 2, part 1

    

    Wednesday Access 2010 Lab 2, part 1 File
  • Select activity Wednesday Access 2010 Lab 2, part 2

    

    Wednesday Access 2010 Lab 2, part 2 File
  • Select activity Wednesday Access 2013 Lab 2, part 1

    

    Wednesday Access 2013 Lab 2, part 1 File
  • Select activity Wednesday Access 2013 Lab 2, part 2

    

    Wednesday Access 2013 Lab 2, part 2 File
  • Select activity Access db for first part of Wednesday lab

    

    Access db for first part of Wednesday lab File

    This is the database you completed in Monday's lab

  • Select activity Stanford Relational Design video

    

    Stanford Relational Design video URL
  • Select activity Ch. 2 ppt

    

    Ch. 2 ppt File
  • Select activity Thursday, April 16

    Thursday, April 16

  • Select activity Thursday reading and hw in Ch. 3

    

    Thursday reading and hw in Ch. 3 Page
  • Select activity There is no scheduled lab BUT

    

    There is no scheduled lab BUT URL
  • Select activity Kroenke Ch. 3 ppt

    

    Kroenke Ch. 3 ppt File
  • Select activity Stanford SQL courseware

    

    Stanford SQL courseware URL
  • Select activity Label

    

  • Select activity See http://www.w3schools.com/sql/sql_injection.asp...

    See http://www.w3schools.com/sql/sql_injection.asp for an explanation of this comic.

  • Select activity Friday, April 17

    Friday, April 17

  • Select activity Friday reading and hw in Ch. 3

    

    Friday reading and hw in Ch. 3 Page
  • Select activity Solutions to Friday's in class SQL problems

    

    Solutions to Friday's in class SQL problems File

    Pay special attention to K--this is a trick you will need to know

  • Select activity Monday, April 20

    Monday, April 20

  • Select activity Appendix E

    

    Appendix E File

    To complete your reading for week 1--coverage of Views on pp. E1 - E16

  • Select activity Intro SQL ppt from Hoffer

    

    Intro SQL ppt from Hoffer File
  • Select activity Intermediate SQL ppt from Hoffer

    

    Intermediate SQL ppt from Hoffer File
  • Select activity Corrected Sample problems from old db exam

    

    Corrected Sample problems from old db exam File

    The last 2 problems would not be appropriate for our first exam

  • Select activity Notes on Exam 1 updated 9:30 p.m.

    

    Notes on Exam 1 updated 9:30 p.m. Page
  • Select activity Monday lab file

    

    Monday lab file
  • Select activity Stanford SQL exercise solutions

    

    Stanford SQL exercise solutions Page
• Select section Week 2

  Week 2

  • Select activity Tuesday, April 21

    Tuesday, April 21

  • Select activity Appendix A--installing SQLServer

    

    Appendix A--installing SQLServer File
  • Select activity Appendix C--installing MySQL

    

    Appendix C--installing MySQL File
  • Select activity Ch. 4 ppt

    

    Ch. 4 ppt File
  • Select activity Chen's E-R paper

    

    Chen's E-R paper File

    The Entity-Relationship Model--Toward a Unified View of Data

  • Select activity Wednesday, April 22

    Wednesday, April 22

  • Select activity Lab 1 of week 2--mySQL tutorial

    

    Lab 1 of week 2--mySQL tutorial Page
  • Select activity Assignment for Wednesday/Thursday

    

    Assignment for Wednesday/Thursday Page
  • Select activity Stanford video on UML data modeling

    

    Stanford video on UML data modeling URL
  • Select activity Thursday, April 23

    Thursday, April 23

  • Select activity Friday, April 24

    Friday, April 24

  • Select activity Ch. 5 ppt

    

    Ch. 5 ppt File
  • Select activity Using MySQL Workbench to draw ER diagrams

    

    Using MySQL Workbench to draw ER diagrams URL
  • Select activity Installing MySQL workbench on Ubuntu

    

    Installing MySQL workbench on Ubuntu Page
  • Select activity EER conversion

    

    EER conversion File
  • Select activity Non-mandatory relationship in MySQL Workbench ERD

    

    Non-mandatory relationship in MySQL Workbench ERD Page
  • Select activity Monday, April 27

    Monday, April 27

  • Select activity Reading and HW assignment for Monday

    

    Reading and HW assignment for Monday Page
  • Select activity Ch. 6 ppt

    

    Ch. 6 ppt File
  • Select activity Database Management issues from Hoffer

    

    Database Management issues from Hoffer File

    esp. Concurrency--I recommend the first 13 slides

  • Select activity Exam 2 outline

    

    Exam 2 outline Page
  • Select activity Old sample Exam 2

    

    Old sample Exam 2 File
  • Select activity Reading and HW assignment for Tuesday

    

    Reading and HW assignment for Tuesday Page
  • Select activity Required viewing--Indexes

    

    Required viewing--Indexes URL
  • Select activity Monday introduction to n-tier systems lab

    Monday introduction to n-tier systems lab

  • Select activity Monday's introduction to n-tier systems lab

    

    Monday's introduction to n-tier systems lab Page
  • Select activity Hoffer php

    

    Hoffer php File
  • Select activity phpmyadmin introduction

    

    phpmyadmin introduction Page
  • Select activity Ch. 5 recursive ERD solution

    

    Ch. 5 recursive ERD solution File
• Select section Week 3

  Week 3

  • Select activity Tuesday, April 28

    Tuesday, April 28

  • Select activity Ch. 7 ppt

    

    Ch. 7 ppt File
  • Select activity Application Development from Hoffer

    

    Application Development from Hoffer File
  • Select activity Wednesday, April 29

    Wednesday, April 29

  • Select activity Day by day for our final week

    

    Day by day for our final week Page
  • Select activity PHP n-tier system project

    PHP n-tier system project

  • Select activity php sample from PHP and MySQL Web Development

    

    php sample from PHP and MySQL Web Development File

    Red Alert: The code in insert_book.php needs a quick edit--The $HTTP_POST_VARS['isbn'} should just be $_POST['isbn'], and similarly below. We're guessing difference in PHP from v. 4.3 to v.5

    From PHP and MySQL Web Development by Welling & Thomson

  • Select activity ALL of the PHP and MySQL projects from Ch. 7

    

    ALL of the PHP and MySQL projects from Ch. 7 File
  • Select activity I will show how to get active web pages up and running during lab on Monday

    

    I will show how to get active web pages up and running during lab on Monday
  • Select activity Here is Appendix I, it will be helpful if you run IIS for your web projects

    

    Here is Appendix I, it will be helpful if you run IIS for your web projects File
  • Select activity Java client/server project

    Java client/server project

  • Select activity Sample JDBC code for the client/server activity

    

    Sample JDBC code for the client/server activity Page
  • Select activity Another, similar, JDBC example

    

    Another, similar, JDBC example Page
  • Select activity Expectations for final project

    

    Expectations for final project Page
  • Select activity Advice about final projects

    

    Advice about final projects Page
  • Select activity Sample final exam project questions from 2007

    

    Sample final exam project questions from 2007 Page
  • Select activity FYI, Presentations Schedule from 2013

    

    FYI, Presentations Schedule from 2013 File
  • Select activity Thursday, April 30

    Thursday, April 30

  • Select activity Class runs from 9:30 to 11:30 on Thursday

    Class runs from 9:30 to 11:30 on Thursday

  • Select activity We will be watching this on Thursday morning, April 30

    

    We will be watching this on Thursday morning, April 30 Page
  • Select activity Ch. 8 ppt

    

    Ch. 8 ppt File
  • Select activity Team meeting times

    

    Team meeting times Page
  • Select activity Friday, May 1

    Friday, May 1

  • Select activity XML from Hoffer

    

    XML from Hoffer File
  • Select activity Stanford XML courseware

    

    Stanford XML courseware URL
  • Select activity Stanford JSON courseware

    

    Stanford JSON courseware URL
  • Select activity Sample JSON

    

    Sample JSON URL
  • Select activity XML tutorial

    

    XML tutorial URL
  • Select activity Monday, May 4

    Monday, May 4

  • Select activity Final Exam guidelines updated 5/3

    

    Final Exam guidelines updated 5/3 Page
  • Select activity Ubuntu LAMP directions for Monday's lab

    

    Ubuntu LAMP directions for Monday's lab Page
  • Select activity Tuesday, May 5

    Tuesday, May 5

  • Select activity Presentation Schedule

    

    Presentation Schedule File
  • Select activity Label

    

• Select section Week 4

  Week 4