COIT12167 Database Use and Design

Relational databases are pervasive in the current society of information technology; designing and building these databases is a challenging and rewarding occupation. This course introduces the student to data modelling, relational database theory and normalisation - essential skills for the design and implementation of relational databases. The problems associated with poorly designed and implemented databases are demonstrated. The important database language SQL is covered in sufficient depth to allow the student to appreciate its potential and limitations. Other topics covered in this course include multi-user database processing, and Internet database applications. During the course, the student will design and implement a small database application using Microsoft Access (or some other product). The course aims to give the student the solid theoretical foundation so essential for working in the field of database design, while also providing an opportunity to apply the theory through the assignment work.