Week 1-2 § Data and Information Database DBMS Database Development Lifecycle Conceptual Database Design Logical Database Design Physical Database Design ER Diagram Data Model Relational Data Model Week 3-4 § Crow’s Foot Notation Relational Algebra SQL SQL Query SQL Aggregate Functions SQL Join SQL Set Operation SQL Subquery Weeks 5-6 § Database File Structure Database Indexing B-Tree B+ Tree Query Processing Query Optimisation Query Plan Weeks 7-8 § Normalisation Functional Dependency Database Transaction Concurrent Transactions Schedule Database Administration Capacity Planning Database Backup And Recovery Weeks 9-10 § Database Warehouse Dimensional Modelling