CS 6360.MS1: Database Design

Course Syllabus   eLearning


Announcements

4/7:  MIT Open Courseware Lecture Notes on User Interface Design

      Ten Common Database Design Mistakes

      CWE/SANS TOP 25 Most Dangerous Software Errors

2/25: Assignment 4 (due 3/24).

Quiz schedule:
Sat, Feb 25	Queries in SQL and Relational Algebra
Sat, Mar 11	E/ER Design, Mapping of ER design to relational model
Fri, Mar 24	Design theory: FD's and Normalization algorithms
Sat, Mar 25	Query optimization, Index files
Sat, Apr 8	Transaction processing, Short questions on database concepts

2/25: Assignment 3 (due 3/12).
      Project (due 4/16).

2/24: Deadline of Assignment 2 changed to Sun, March 5.

2/11: Assignment 2 (due 3/5 [was 2/25]).

1/27: Assignment 1 (due 2/11).
      Quiz in class on Sat, Feb 11.  Format: Closed book and notes.
      Topics: Queries in SQL and Relational Algebra.

Proposed schedule:

No. Date   Chapter  Topics
 1  Jan 14  1,2,5   Introduction, History of DB, DB Concepts, Relational model
 2  Jan 27    5-7   Relational model, Relational Algebra, SQL
 3  Jan 28    7-8   Relational model, SQL, Relational Calculus, Embedded SQL
 4  Feb 11  3-4,9   Data modeling, ER model, EER model, UML
 5  Feb 24     14   Database design process, Functional dependencies
 6  Feb 25     15   Normal forms, Normalization algorithms
 7  Mar 11  10-11   Practical aspects of DB, SQL programming, Demo application
 8  Mar 24  16-19   Files, Data storage, Indexing, Optimization
 9  Mar 25  20-22   Transaction processing, Serializability, Recovery
10  Apr 08     30   Security, Case studies, New directions


Return to Balaji Raghavachari's home page.