CS 6360.MS1: Database Design

Course Syllabus   eLearning


Instructor:    Balaji Raghavachari
               [email protected]
               ECSS 4.225

Office hours:  Wed 12:00 noon-2:00 PM, and by appointment.

Announcements 4/13: Assignment 4 (due Sun, Apr 28, on elearning). 3/2: Assignment 3 (due Sun, Mar 31 [was Mar 24], on elearning). 2/16: Project. Assignment 2 (due Sun, Mar 10, on elearning). 2/1: Assignment 1 (due Sun, Feb 17, on elearning). 1/7: Course Syllabus (Ver 1.2) Proposed schedule: No. Date Chapter Topics 1 Jan 12 1,2,5 Introduction, History of DB, DB Concepts, Relational model 2 Feb 1 5-7 Relational model, Relational Algebra, SQL 3 Feb 2 7-8 Relational model, SQL, Relational Calculus, Embedded SQL 4 Feb 16 3-4 Data modeling, ER model, EER model, UML 5 Mar 1 9,14 Mapping, Database design process, Functional dependencies 6 Mar 2 15 Normal forms, Normalization algorithms 7 Mar 30 16-18 Mid-term exam, Files, Data storage, Indexing, Optimization 8 Apr 12 19-21 Query optimization, Transaction processing, Serializability 9 Apr 13 22-23 Recovery, Distributed databases, Case studies 10 Apr 27 30 Final exam, Security, New directions, UI Design