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.