Learning Outcomes At the end of this course, students should be able to:
describe database systems concepts and design;
explain database models and construction;
explain database implementation with SQL; and
describe database management and security.
Course Contents Database concepts. File versus database systems, data models, ANSI/SPARC 3-level view of a database, and the relational database model and its advantages over older and even emerging models. Design concepts and implementation: entity relationship modelling. Normalisation of database tables, structured query language. Database design and implementation. Introduction to transaction management and concurrency control, distributed database management systems. Database privacy, security, failure and recovery. Some emerging topics in databases such as semi-structured (XML or NoSQL) databases and objectoriented database systems.
Lab work: Practical exercise on information representation, capture, storage and retrieval. Learn how to analyse data and index for easy searching and indexing. Practical on creating database files and models. How to create and use various database designs. How to query the created database. Methods of concurrency and recovery in database. Learn how to secure the database.
