To familiarise students with the principles of database management systems, to enable them to design and implement databases for specific applications and to integrate databases with application programs.
1. Database Design (1.1 data requirements, entity relationship diagrams, relational data model, integrity constraints, key constraints, types, integrity maintenance)
2. Relational Queries (2.1 SQL, Boolean combinations of queries, aggregation, duplicate elimination, nested queries, negation, views, insertions, deletions, updates)
3. Query execution and optimisation (3.1 data storage principles, file organisation, indexing, indexes in commercial DBMSs, relational algebra, query execution plans, cost estimation of plans, interpretation of plans, physical database design, transactions, schedules, serialisability, concurrency control protocols, locking, two-phase-locking, time stamp based concurrency control.)
4. Emerging Database Trends (4.1 Data warehousing, distributed databases, and alternative database models such as XML, document, object, and graph stores)
By the end of the course, students should be able to do the following:
Curriculum explorer: Click here
SCQF Level: 8
Credits: 15