Back to main page

Fundamentals of Database Systems

General Information

Course objectives Class hours: Fix in the class OT
Midterm & Final Examinations:
Previous ExaminationsPlease email to me

Ramez Elmasri & Shamkant B. Navathe, Fundamentals of Database Systems, 6nd Edition, Addison-Wesley.

Course Materials

In this course, the following selected chap's are only provided.
Chapter 1. Databases and Database Users.
Chapter 2. Database System Concepts and Architecture. (Lecture Slide)
Chapter 3. The Relational Data Model and Relational Database Constraints.
Chapter 4. Basic SQL. (Lecture Slide)
Chapter 5. More SQL: Complex Queries, Triggers, Views, and Schema Modification. (Lecture Slide)
Chapter 6. The Relational Algebra and Relational Calculus.
Chapter 7. Data Modeling Using the Entiry-Relationship (ER) Model.
Chapter 9. Relational Database Design by ER and EER-to-Relational Mapping.
     (Note that EER is beyond the class.)
Chapter 15. Basics of Functional Dependencies and Normalization for Relational Databases.