615-230 Database Concepts

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 attempting 615-230. Students inexperienced in using Delphi will need to acquire this skill in their own time.

Topics may include, but are not restricted to, the following: the managerial view of data, information, and knowledge; data modelling 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.

One 3-hour end-of-semester exam, and 40 hours of individual and group project work. The weighting of the assessment components will be announced at the commencement of the subject. Successful completion of this subject requires a pass in both the exam and the practical portion of the assessment.