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 (development, query processing and optimisation); and database and data management. Some 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.

Assigned project work expected to average six hours per week due during the semester (40%); a 3-hour written examination in the examination period (60%). Satisfactory completion of both project work and the examination is necessary to pass the subject.