615-230 Database Concepts

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

Students may not gain credit for both this subject and either 433-351 or 433-258.

615-145 Concepts in Software Development I. Students who receive a credit or exemption for 615-145 should be aware that prior knowledge of and experience in using Delphi programming is assumed for students enrolling in this subject.

Topics will be chosen from the following list: the managerial view of data, information, and knowledge; data modeling for relational databases; SQL; database architectures and implementations; non-relational databases such as hierarchical, network, and object-oriented databases; data integrity; data warehousing; data administration; and alternative organisational memory technologies such as groupware.

On completing this subject, students should be familiar with:

• the role databases have within organisations;

• database design;

• database manipulation; and

• data administration.

Students should develop the practical skills needed for the analysis of complex business systems, and for the design of solutions in the context of those systems. They should also gain skills needed to collaborate in groups to solve problems quickly and efficiently.

One 3-hour end-of-semester exam (60%); 40 hours of individual and group project work (40%).