CSC304: Databases 6 credits (40-5-15)

Objectives

To explore how information (data) may be stored for easy updates and retrieval, the applications of database management systems, such as in business as well as the use of a relational database, and various techniques for obtaining and analysing data in order to build a database system.

Contents

Applications of database management systems; importance and requirements of database management systems; role of database administrator; data definition and data manipulation languages; models and schemes; relational database model: introduction; introductory relational algebra; normal forms and normalization procedures (up to third normal form); examples of relational databases; Use of entity Relationship model (including traps); Collecting and using information e.g. interviews, observations, data collection; Introduction to other models of databases: networked and hierarchical models; Comparison of database models.

Prerequisite:

CSC202 or CSC204