Schedule Summer 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 Chapter Lectures Quizzes Notes
1 Mon, May 22, 2017 1 Basic Database Concepts
c1.1  c1.2  c1.3  
LV1  LV2 Database Concepts
2 Wed, May 24, 2017 2 Relations and Relvars
c2.1  c2.2  c2.3  
LV1  LV2 Relations and Relvars
3 Fri, May 26, 2017 3 Keys, Foreign Keys, and Related Matters
c3.1  c3.2  c3.3  
LV1  LV2 Keys and Foreign Keys
MINUS and INTERSECT in MySQL
Mon, May 29, 2017 Memorial Day
4 Wed, May 31, 2017 4 Relational Operators I
c4.1  c4.2  c4.3  c4.4  c4.5  
LV1 Relational Operators
Assignment 1 Due
5 Fri, Jun 2, 2017 5 Relational Operators II
c5.1  c5.2  c5.3  
LV1  LV2 Relational Operators II
6 Mon, Jun 5, 2017 6 Constraints and Predicates
c6.1  c6.2  c6.3  
LV1  LV2 Constraints
7 Wed, Jun 7, 2017 7 The Relational Model
c7.1  c7.2  
LV1  LV2 Relational Model
8 Fri, Jun 9, 2017 8 Transactions
c8.1  c8.2  
LV1  LV2 Optimistic Concurrency
Assigment 2 Due
Mon, Jun 12, 2017 Kamehameha Day
9 Wed, Jun 14, 2017 9 Database Design
c9.1  c9.2  c9.3  
LV1 Normal Forms
10 Fri, Jun 16, 2017 10 SQL Tables
c10.1  c10.2  c10.3  
LV1 Normal Forms 2
11 Mon, Jun 19, 2017 11 SQL Operators I
c11.1  c11.2  c11.3  c11.4  
LV1 Extend Operator
12 Wed, Jun 21, 2017 12 SQL Operators II
c12.1  c12.2  c12.3  
LV1 Entity Relationship Diagrams
Entity Relationship Diagrams
13 Fri, Jun 23, 2017 13 SQL Constraints
c13.1  
LV1  LV2 Entity Relationship Diagrams II
Assignment 3 Due
14 Mon, Jun 26, 2017 14 SQL vs. the Relational Model
c14.1  c14.2  
LV1 Stored Procedures
(No Assignment 4)
15 Wed, Jun 28, 2017 Triggers/Stored Procedures LV1 Normal Forms/Triggers
16 Fri, Jun 30, 2017 Help on Assignment 3 LV1 eCafe Survey
Assignment 5 Due