CS6360.004 Schedule Fall 2019

Instructor: John Cole

This schedule is tentative and subject to change.  All readings are in Fundamentals of Database Systems, Seventh Edition.

Week Date Topic

Reading

1 August 19 Syllabus review, course requirements, etc. Ch. 1
August 21 Database Concepts Ch. 2
2 August 26 The Entity-Relationship (ER) Model Ch. 3
  August 28 The Entity-Relationship model Ch. 3
3 September 2

Labor Day holiday

 
  September 4  Basic SQL Ch. 6
4 September 9 The Enhanced Entity-Relationship Model Ch. 4
  September 11 The Enhanced Entity-Relationship Model Ch. 4
5 September 16

More SQL

Ch. 7
  September 18 The Relational Model and Relational Database Constraints Ch. 5
6 September 23 The Relational Model and Relational Database Constraints Ch. 5
  September 25 Relational database design by ER to EER mapping Ch. 9
7 September 30 Relational database design by ER to EER mapping Ch. 9
  October 2 Midterm Review
8 October 7

Exam 1 on Chapters 1-5, 7, and 9

  October 9

Relational Algebra and Calculus

Ch. 8
9 October 14

Relational Algebra and Calculus

Ch. 8
October 16 File Structures Ch. 16
10 October 21 File Structures / Index Structures Ch. 16, 17
  October 23 Index Structures Ch. 17
11 October 28 Functional Dependency and Normalization Ch. 14
  October 30 Functional Dependency and Normalization Ch. 14
12 November 4 Design Algorithms & Further Dependencies Ch. 15
  November 6 Design Algorithms & Further Dependencies Ch. 15
13 November 11 Query Processing & Optimization Ch. 18
  November 13 Query Processing & Optimization Ch. 19
14 November 18 Transaction Processing  
  November 20 Concurrency Control  
15 November 25 Fall Break for Thanksgiving Ch. 20
  November 27 Fall Break for Thanksgiving Ch. 21
16 December 2 Exam Review  
  December 4 Exam 2 at 8:30 to 9:45 in the TI Auditorium, ECSS 2.102
Covers Chapters 8, 14, 15, 16, 17, 18, 19
, and the material on transactions and concurrency (In class)