Chapters (in the 5th edition) included  for the Final Exam:


Chapter 6 SQL: Data Manipulation
Chapter 7 SQL: Data Definition
Chapter 12 Entity Relationship Modeling
Chapter 14 Normalization
Chapter 16 Methodology: Conceptual Database Design
Chapter 17 Methodology: Logical 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 and 
          logical design - 35 points


Section E: Deriving relations using DBDL from ERD - 16 points



Examples for Relations:

Branch(BranchNo, street, address, city, postcode)
Primary key BranchNo,
Alternate key postcode.


Staff(StaffNo, fName, lName, position, sex, salary, BranchNo)
Primary key StaffNo,
Foreign key (BranchNo) references Branch (BranchNo);