Pre-requisite: 66202
Firstly, an overview of the structure of relational database systems is given. The Entity-Relationship model is then studied. The relational algebra and relational calculus are covered in detail. Query languages SQL, QBE, and Quel are studied with the emphasis on SQL. This unit requires the students to have good understanding of functional dependencies, various normal forms, and relational database design principles. Other topics of this unit include integrity constraints, indexing and B-trees, and query processing.