Course: CSC314-1 2016: Data Management Systems

Topic outline

General
General
Week 1
Week 1
- Monday, September 5
- Stanford Database course video URL
- Tuesday video assignment URL
- Monday Week 1 assignment Page
- COBOL URL
  Results of a survey related to COBOL.
- Tuesday, September 6
- Rudimentary Access 2010 "Workbench" tutorial part 1 File
- Rudimentary Access 2010 "Workbench" tutorial part 2 File
- Rudimentary Access 2010 "Workbench" tutorial last part File
- Tuesday Stanford video URL
- Stanford Relational Algebra video URL
- 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:30.
- E. F. Codd's paper File
  A Relational Model of Data for Large Shared Data Banks
- Wednesday, September 7
- Reading and HW Assignment for Wednesday Page
- Access database for lab 2 File
  Imagine tracking client contacts in the table you built in Tuesday's lab. This would exhibit the kind of redundancies we discussed in class on Monday, and would be subject to all sorts of modification anomalies. Fixing that architecture is the purpose of today's lab.
- Wednesday Access 2010 Lab 2, part 1 File
- Wednesday Access 2010 Lab 2, part 2 File
- Thursday, September 8
- Thursday/Friday viewing,reading and hw Page
- Stanford Relational Design video URL
- Lab 3 Folder
- BCNF from Kroenke, as promised File
- Friday, September 9
- BCNF homework File
- Chen's E-R paper File
  The Entity-Relationship Model--Toward a Unified View of Data
- EER Diagram slides File
- Monday, September 12
- Monday video, reading and hw Page
- Stanford video on UML data modeling URL
- Using MySQL Workbench to draw ER diagrams URL
- ER diagram lab Page
- Tuesday, September 13
- Tuesday video, reading and hw Page
- Lab 1 of week 2--mySQL tutorial Page
- Wednesday, September 14
  Exam 1 is from 9 to 11 in our Law 113 lab classroom
- Notes on Exam 1 Page
- Sample Exam 1 problems File
- Some interesting links related to our first exam Page
Week 2
Week 2
- Thursday, September 15
- W3 Schools SQL link--practice as you read URL
  you should spend 45 minutes each of the next 2 days going through these tutorials--
- Stanford SQL courseware URL
- Thursday SQL lab file
- Assignment for Thursday/Friday of week 2 Page
- Solutions to Thursday's in class SQL problems File
  Pay special attention to K--this is a trick you will need to know
- Friday, September 16
- Non-mandatory relationship in MySQL Workbench ERD Page
- Please submit your group's SQL quiz solutions here Forum
- Stanford DB10 videos Indices and Transactions URL
- Additional reading on concurrency and transactions from Hoffer File
- Recommended Ch. 6 exercises Page
- Monday, September 19
  Transactions, Constraints, Triggers, Views, Indices
- Reading and Viewing assignment for Friday - Tuesday Page
- DB11 Videos--Constraints and Triggers URL
- Monday's Lab--Workbench, hands-on constraints Page
- Intermediate SQL ppt from Hoffer (nice coverage of DDL constraints) File
- Issues in db administration ppt File
- Database installation guides Folder
- Tuesday, September 20
- DB12 Videos--Views URL
- Appendix E File
  Extra coverage of Views on pp. E1 - E16
- Required DB10 viewing--Indexes URL
- Introduction to php/MySQL n-tier systems lab
- Tuesday's introduction to n-tier systems lab Page
- phpmyadmin introduction Page
- See http://www.w3schools.com/sql/sql_injection.asp for an explanation of this comic.
- Wednesday, September 21
- Exam 2 outline Page
- Recommended exercises to prepare for Exam 2 Page
- Sample problems from old exams for Exam 2 (updated 9:30 pm 9-22-16) File
- Application Development from Hoffer File
- PHP/MySQL n-tier lab and assignment
- php/MySQL Wednesday lab activity Page
- Solution to Workshop/Joke tutorial File
- Annotated php from Hoffer File
- FYI, Ubuntu permissions directions from 2015 CSC314 Page
- FYI, 2015 CSC314 Ubuntu LAMP directions for lab Page
Week 3
Week 3
- Day by day for our final week Page
- Expectations for final project Page
- Succinct advice about final projects and presentations Page
- Sample final exam project questions from 2007 Page
- FYI, Presentations Schedule from 2013 CSC314 File
- FYI, Presentation Schedule from 2015 CSC314 File
- Thursday, September 22
- Java client/server lab
- Tips for JDBC lab Page
- Sample JDBC code for the client/server activity Page
- Another, similar, JDBC example Page
- Friday, September 23
  Exam 2 is from 9 a.m. to 11:30 a.m. in our Law 113 Lab/classroom
- Monday, September 26
- Stanford XML courseware URL
- Stanford JSON courseware URL
- Sample JSON URL
- XML tutorial URL
  Highly recommended, again from W3 schools
- JSON tutorial URL
  This is hidden under W3 schools Javascript tutorial. I wonder why?
- Tuesday, September 27
- Final Exam problem list (no changes from earlier version) Page
- Final Exam guidelines updated 5/3 Page
- Project presentations topics, teams, and schedule File
- Note on good stuff in text and videos we won't be covering Page
Week 4
Week 4