CSC314-1 2016: Data Management Systems

Section outline

• Select section General

  General

  Collapse all Expand all

  • Select activity News forum

    

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

    

    CSC314-1 Database Management Systems syllabus File
  • Select activity Projects Forum

    

    Projects Forum
  • Select activity Ideas for topics for your projects

    

    Ideas for topics for your projects Page
  • Select activity Database manager interview forum

    

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

    

    Grading cutoffs for our course Page
• Select section Week 1

  Week 1

  • Select activity Monday, September 5

    Monday, September 5

  • Select activity Stanford Database course video

    

    Stanford Database course video URL
  • Select activity Label

    

  • Select activity Tuesday video assignment

    

    Tuesday video assignment URL
  • Select activity Monday Week 1 assignment

    

    Monday Week 1 assignment Page
  • Select activity COBOL

    

    COBOL URL

    Results of a survey related to COBOL.

  • Select activity Tuesday, September 6

    Tuesday, September 6

    
    

  • 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 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:30.

  • 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 Wednesday, September 7

    Wednesday, September 7

  • Select activity Reading and HW Assignment for Wednesday

    

    Reading and HW Assignment for Wednesday Page
  • Select activity Access database for lab 2

    

    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.

  • 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 Thursday, September 8

    Thursday, September 8

  • Select activity Thursday/Friday viewing,reading and hw

    

    Thursday/Friday viewing,reading and hw Page
  • Select activity Stanford Relational Design video

    

    Stanford Relational Design video URL
  • Select activity Lab 3

    

    Lab 3 Folder
  • Select activity BCNF from Kroenke, as promised

    

    BCNF from Kroenke, as promised File
  • Select activity Friday, September 9

    Friday, September 9

  • Select activity BCNF homework

    

    BCNF homework 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 EER Diagram slides

    

    EER Diagram slides File
  • Select activity Monday, September 12

    Monday, September 12

  • Select activity Monday video, reading and hw

    

    Monday video, reading and hw Page
  • Select activity Stanford video on UML data modeling

    

    Stanford video on UML data modeling URL
  • Select activity Using MySQL Workbench to draw ER diagrams

    

    Using MySQL Workbench to draw ER diagrams URL
  • Select activity ER diagram lab

    

    ER diagram lab Page
  • Select activity Tuesday, September 13

    Tuesday, September 13

    
    

  • Select activity Tuesday video, reading and hw

    

    Tuesday video, reading and hw Page
  • Select activity Lab 1 of week 2--mySQL tutorial

    

    Lab 1 of week 2--mySQL tutorial Page
  • Select activity Wednesday, September 14Exam 1 is from 9 to 11 in o...

    Wednesday, September 14

    Exam 1 is from 9 to 11 in our Law 113 lab classroom

  • Select activity Notes on Exam 1

    

    Notes on Exam 1 Page
  • Select activity Sample Exam 1 problems

    

    Sample Exam 1 problems File
  • Select activity Some interesting links related to our first exam

    

    Some interesting links related to our first exam Page
• Select section Week 2

  Week 2

  • Select activity Thursday, September 15

    Thursday, September 15

  • Select activity W3 Schools SQL link--practice as you read

    

    W3 Schools SQL link--practice as you read URL

    you should spend 45 minutes each of the next 2 days going through these tutorials--

  • Select activity Stanford SQL courseware

    

    Stanford SQL courseware URL
  • Select activity Thursday SQL lab file

    

    Thursday SQL lab file
  • Select activity Assignment for Thursday/Friday of week 2

    

    Assignment for Thursday/Friday of week 2 Page
  • Select activity Solutions to Thursday's in class SQL problems

    

    Solutions to Thursday's in class SQL problems File

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

  • Select activity Friday, September 16

    Friday, September 16

  • Select activity Non-mandatory relationship in MySQL Workbench ERD

    

    Non-mandatory relationship in MySQL Workbench ERD Page
  • Select activity Please submit your group's SQL quiz solutions here

    

    Please submit your group's SQL quiz solutions here Forum
  • Select activity Stanford DB10 videos Indices and Transactions

    

    Stanford DB10 videos Indices and Transactions URL
  • Select activity Additional reading on concurrency and transactions from Hoffer

    

    Additional reading on concurrency and transactions from Hoffer File
  • Select activity Recommended Ch. 6 exercises

    

    Recommended Ch. 6 exercises Page
  • Select activity Monday, September 19Transactions, Constraints, Tri...

    Monday, September 19

    Transactions, Constraints, Triggers, Views, Indices

  • Select activity Reading and Viewing assignment for Friday - Tuesday

    

    Reading and Viewing assignment for Friday - Tuesday Page
  • Select activity DB11 Videos--Constraints and Triggers

    

    DB11 Videos--Constraints and Triggers URL
  • Select activity Monday's Lab--Workbench, hands-on constraints

    

    Monday's Lab--Workbench, hands-on constraints Page
  • Select activity Intermediate SQL ppt from Hoffer (nice coverage of DDL constraints)

    

    Intermediate SQL ppt from Hoffer (nice coverage of DDL constraints) File
  • Select activity Issues in db administration ppt

    

    Issues in db administration ppt File
  • Select activity Database installation guides

    

    Database installation guides Folder
  • Select activity Tuesday, September 20

    Tuesday, September 20

  • Select activity DB12 Videos--Views

    

    DB12 Videos--Views URL
  • Select activity Appendix E

    

    Appendix E File

    Extra coverage of Views on pp. E1 - E16

  • Select activity Required DB10 viewing--Indexes

    

    Required DB10 viewing--Indexes URL
  • Select activity Introduction to php/MySQL n-tier systems lab

    Introduction to php/MySQL n-tier systems lab

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

    

    Tuesday's introduction to n-tier systems lab Page
  • Select activity phpmyadmin introduction

    

    phpmyadmin introduction Page
  • 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 Wednesday, September 21

    Wednesday, September 21

  • Select activity Exam 2 outline

    

    Exam 2 outline Page
  • Select activity Recommended exercises to prepare for Exam 2

    

    Recommended exercises to prepare for Exam 2 Page
  • Select activity Sample problems from old exams for Exam 2 (updated 9:30 pm 9-22-16)

    

    Sample problems from old exams for Exam 2 (updated 9:30 pm 9-22-16) File
  • Select activity Application Development from Hoffer

    

    Application Development from Hoffer File
  • Select activity PHP/MySQL n-tier lab and assignment

    PHP/MySQL n-tier lab and assignment

  • Select activity php/MySQL Wednesday lab activity

    

    php/MySQL Wednesday lab activity Page
  • Select activity Solution to Workshop/Joke tutorial

    

    Solution to Workshop/Joke tutorial File
  • Select activity Annotated php from Hoffer

    

    Annotated php from Hoffer File
  • Select activity FYI, Ubuntu permissions directions from 2015 CSC314

    

    FYI, Ubuntu permissions directions from 2015 CSC314 Page
  • Select activity FYI, 2015 CSC314 Ubuntu LAMP directions for lab

    

    FYI, 2015 CSC314 Ubuntu LAMP directions for lab Page
• Select section Week 3

  Week 3

  • Select activity Day by day for our final week

    

    Day by day for our final week Page
  • Select activity Expectations for final project

    

    Expectations for final project Page
  • Select activity Succinct advice about final projects and presentations

    

    Succinct advice about final projects and presentations 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 CSC314

    

    FYI, Presentations Schedule from 2013 CSC314 File
  • Select activity FYI, Presentation Schedule from 2015 CSC314

    

    FYI, Presentation Schedule from 2015 CSC314 File
  • Select activity Thursday, September 22

    Thursday, September 22

  • Select activity Java client/server lab

    Java client/server lab
    

  • Select activity Tips for JDBC lab

    

    Tips for JDBC lab Page
  • 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 Friday, September 23Exam 2 is from 9 a.m. to 11:30...

    Friday, September 23

    Exam 2 is from 9 a.m. to 11:30 a.m. in our Law 113 Lab/classroom

  • Select activity Monday, September 26

    Monday, September 26

  • 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

    Highly recommended, again from W3 schools

  • Select activity JSON tutorial

    

    JSON tutorial URL

    This is hidden under W3 schools Javascript tutorial. I wonder why?

  • Select activity Tuesday, September 27

    Tuesday, September 27

  • Select activity Final Exam problem list (no changes from earlier version)

    

    Final Exam problem list (no changes from earlier version) Page
  • Select activity Final Exam guidelines updated 5/3

    

    Final Exam guidelines updated 5/3 Page
  • Select activity Project presentations topics, teams, and schedule

    

    Project presentations topics, teams, and schedule File
  • Select activity Note on good stuff in text and videos we won't be covering

    

    Note on good stuff in text and videos we won't be covering Page
• Select section Week 4

  Week 4