Syllabus

  1. Introduction to Databases

  2. Relational Model, Relational Algebra and Calculus

  3. SQL

  4. QBE

  5. Physical Storage Structures and Strategies

  6. Query Processing and Optimization [First project due]

  7. Integrity Constraints and Functional Dependencies [Midterm]

  8. Normal Forms, Database Design, Entity-Relationship Model

  9. Crash Recovery, Concurrency Control and Transactions 

10.  Distributed Databases and distributed transactions [Second Project due]

11. Final Exam (12/13)

• Midterm 30%
• Final 40%
• Projects 2 x 10%
• Homework 10%

• Abraham Silberschatz, Henry F. Korth, S. Sudarshan Database System Concepts: Fourth Edition, McGraw-Hill. [Required]
• Raghu Ramakrishnan, Database Management Systems, 1st ed. McGraw-Hill, 1997.
• Jeff Ullman, Jennifer Widom, A First Course in Database Systems, Prentice Hall, 1997.