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