Section: Week 1 | CSC314-8 2014: Data Management Systems

Section outline

- 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

Section outline

Monday, April 13

Tuesday, April 14

Wednesday, April 15

Thursday, April 16

Friday, April 17

Monday, April 20