Topic
1.Introduction to databases. Database environment. DreamHome case study.
2.Database analysis and design. Entity-Relationship (ER) modeling and UML domain model.
3.Enhanced Entity-Relationship (EER) modeling.
4.The relational model. Normalisation.
5.Logical database design for the relational model.
6.Relational algebra – basic operations.
7.SQL : Data definition..
8.SQL: Simple queries
9.SQL: Multi-table queries.
10.SQL: Sub-queries.
11.SQL: Stored procedures and triggers.
12.XML and databases.
