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 include database administration; physical database design and implementation; emerging database technologies; relational database issues (query processing and optimisation); and database and data management. One of the department's industry partners may provide assistance in the subject's delivery. This subject builds upon students' understanding of topics such as logical database design and SQL.

At the completion of this subject, students should:

• be able to develop the physical design required of a large database system;

• be able to implement a large database; and

• be able to manage large databases efficiently

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;

• written and oral communication skills; and

• confidence to tackle unfamiliar problems.

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