615-330 Advanced Concepts in Database

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

A grade of at least H3 for 615-230 Database Concepts and successful completion of 62.5 points of 200-level information systems subjects.

Topics will be chosen from the following list: database administration; advanced data modeling (focusing on relational but possibly including network, hierarchical and object oriented); relational database issues (query processing, and optimisation); data management; and database application development. This subject may include heavy involvement from one of the department's industry partners.

At the completion of this subject, students should:

• have an in-depth knowledge of the relational database model;

• be able to manage databases efficiently; and

• be able to build moderately complex database applications and SQL queries.

Students will also acquire and extend other valuable, generic skills through solving the problems encountered throughout the subject. These include:

• analytic and problem-solving skills;

• application of theory to practice in IS database management;

• communication skills, written and oral; and

• confidence to tackle unfamiliar problems.

An end-of-semester written examination of up to three hours (50%) and assigned project work expected to average six hours per week (50%).