Chapters included  for the Final Exam, April 21, 2003:

Chapter 3 The Relational Model
Chapter 5 SQL: Data Manipulation
Chapter 6 SQL: Data Definition
Chapter 11 Entity Relationship Modeling
Chapter 13 Normalization
Chapter 14 Methodology: Conceptual Database Design
Chapter 15 Methodology: Logical Database Design
Chapter 16: Methodology: Physical Database Design

Chpaters Not included:
Chapter 1 Introduction to Databases
Chapter 2 Database Environment


Duration of the Exam: 2 Hrs. 30 Minutes
Maximum points: 100


Section A: Normalization - 15 points
Section B: Drawing ERD and deriving relations - 18 points
Section C: SQL commands based on tables - 16 points
Section D: Short answer Questions on Conceptual, 
           logical, and physical design - 35 points
Section E: Deriving relations using DBDL from ERD - 16 points