DTS 304 Data Management I

Learning Outcomes
At the end of this course, students should be able to:
1. describe database systems concepts and design;
2. explain database models and construction;
3. explain database implementation with SQL; and
4. 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.