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.

This subject provides an introduction to the concepts of database management. The subject will examine the development of database management which include database analysis, design and implementation. In addition, advanced database topics such as data warehousing, online analytical processing, and data mining are also covered.

At the conclusion of this subject students should be able to:

• perform conceptual data modelling using the basic and enhanced entity-relationship modelling techniques and implement developed models in a relational database management system;

• create, define, enter data, and query (using SQL) a relational database;

• develop client-server applications;

• describe the role databases play in modern enterprises; and

• list and describe the key activities in information resource management and their relationship to the organisation.

Individual data modelling work during semester (15%); a group project due during the semester (20%); ongoing tutorial/laboratory work during the semester (5%); a 2-hour written examination in the examination period (60%). Satisfactory completion of the examination, modelling, project and tutorial work is necessary to pass the subject.