Final Exam Syllabus



The final exam is all inclusive, it will test all material 
covered in this course (although, more emphasis will be on 
the material that is post mid-term).
The final exam is worth 40% of the course points.

The exam will cover:

   1. Basic elements of Database Management System
   2. Database Modeling / Entity-Relationship
   3. Relational Algebra / Relational Calculus
   4. SQL (Structured Query Language)
	- DML (Data Manipulation Language)
 	- DDL (Data Definition   Language)
   5. Integrity Constraints
	- Key Constraint
	- Domain Constraint
	- Referential Integrity
	- Functional Dependencies
	- Assertions
	- Triggers    
   6. Database Design
	- BCNF
	- 3NF
   7. Indexes
	- Index Sequential Files
	- Dense & Sparse Indexes
	- Primary & Secondary Indexes
	- B+ & B Trees
	- Hashings
   8. Transaction Processing
	- Atomicity
	- Recovery
	- Concerrency


Read up the following materials: - Class Notes - Slide posted on the course home page - Prescribed Text book - Reference Book The material of relevance in the Prescribed Text book is: (Ignore the Object Oriented concepts in the chapters in the text book.) Chapter 1 Chapter 2 (minus 2.1 & 2.7) Chapter 3 (3.1, 3.3, 3.5, 3.6, 3.7) Chapter 4 (4.1, 4.3, 4.5, 4.7) Chapter 5 (minus 5.10) Chapter 6 Some topics are covered (entirity or in a better fashion in the reference book, posted on the main course page.) Chapters of relevance in the reference book are: Chapter 5 Chapter 6 (6.1 & 6.2) Chapter 8 Chapter 10