Schedule Spring 2017

Course Slides. When you click on a link you may be asked for a username and password. The username is ics321 and the password is the 5-digit CRN for the course.

Day Date Chapter Lecture Topic Quiz Topic Assignment
1 Mon Jan 9 Vid_001 Ch. 1 Introduction, Syllabus Introductions
2 Wed Jan 11 Vid_002 Vid_003 Ch. 1 Basic Database Concepts Reference Database Controls
Mon Jan 16 (MLK Holiday)
3 Wed Jan 18 Vid_004 Vid_005 Vid_006 Ch. 2 Relations and Relvars Relational Variables
4 Mon Jan 23 Vid_007 Vid_008 Vid_009 Ch. 3 Keys, Foreign Keys, and Related Matters Keys and Foreign Keys
5 Wed Jan 25 Vid_010 Ch. 4 Relational Operators Product and Join Assignment 1a. Create the Suppliers-Parts database on your class server. Due Monday 2/13/17. You can watch this video and use this spreadsheet.
6 Mon Jan 30 Vid_011 Vid_012 Ch. 4 Relational Operators Intersect and Difference Lecture notes. Lecture video. Assignment 1b: Create a database named WPC using this schema which is used for the quiz.
7 Wed Feb 1 Vid_013 Vid_014 Ch. 4 Relational Operators More Tutorial D and MySQL
8 Mon Feb 6 Vid_015 Ch. 4 Assignment Statements
9 Wed Feb 8 Vid_016 Ch. 5 Images
10 Mon Feb 13 Vid_017 Ch. 5 Aggregation Assignment 1 due
11 Wed Feb 15 Vid_018 Vid_019 Vid_020 Ch. 6 Constraints and Predicates Constraints and Predicates
Mon Feb 20 (Presidents Day)
12 Wed Feb 22 Vid_021 Vid_022 Ch. 7 The Relational Model Relational Model
13 Mon Feb 27 File Organization Reference Relational Model Assignment 2 will be discussed. See video.
14 Wed Mar 1 Hashed and indexed files Storage Engines MySQL Search Engine Comparisons here and here.
15 Mon Mar 6 Transactions including ACID Transactions
16 Wed Mar 8 Database Design – Normal Forms Functional Dependencies Assignment 2 Due
17 Mon Mar 13 Vid_023 Vid_024 Ch. 8 Database Design – Normal Forms Normal Forms Assignment 5 (Due Monday May 8).
18 Wed Mar 15 Vid_025 Ch. 9 Database Design – Normal Forms Assignment 3 Places click here.
19 Mon Mar 20 Vid_026 Ch. 9 Class Video (not edited) Assignment 4 Places Check-In App
20 Wed Mar 22 Vid_027 Ch. 9 Class Video (not edited)
Mon Mar 27 (Spring Recess)
Wed Mar 29 (Spring Recess)
21 Mon Apr 3 Vid_028 Vid_029 Vid_030 Ch. 10 Rotating Drives Reference Access Times
22 Wed Apr 5 Vid_031 Vid_032 Vid_033 Ch. 11 Solid State Drives Reference Access Times 2
23 Mon Apr 10 Vid_034 Ch. 11 Class Video (not edited) Intro to triggers and transactions for Assignment 4
24 Wed Apr 12 Vid_035 Vid_036 Vid_037 Ch. 12 SQL Tables, Operators Relations/Tables
25 Mon Apr 17 Vid_038 Ch. 13 SQL Constraints (p. 194, 202)
26 Wed Apr 19 Vid_039 Vid_040 Ch. 14 SQL vs. the Relational Model (p. 211)
27 Mon Apr 24 Entity Relationship Diagrams Reference (TBD) Transactions
28 Wed Apr 26 Entity Relationship Data Model Class Video (not edited) Reference (TBD)
29 Mon May 1 Review Class Video (TBD) Triggers
30 Wed May 3 Review Class Video