615-330 Advanced Concepts in Database

Note

This subject is regarded as a non-science subject for students enrolled in the single BSc and combined BSc courses.

Credit Points

Coordinator

Prerequisites

615-230 Database Concepts

Semester

Contact

Subject Description

Aspects of the following topics will be considered: advanced data modelling, focusing on relational but possibly including network, hierarchical, and others; relational database issues (query processing, and optimisation); object-oriented databases (design and query languages); data management; and database application development.

At the completion of this subject, students should:

• have an in-depth knowledge of the relational database model;
• have a working knowledge of some non-relational database models;
• be able to write efficient database queries in Structured Query Language (SQL);
• be able to build moderately complex database applications.

Assessment

A 3-hour end-of-semester written examination; assigned project work. Weighting of the assessment components will be announced at the commencement of the subject.