Created as part of the Master of information Technology and Master of Applied Information Technology Units - 2009

This unit has been updated as part of a 2009 review and comparison of data with current Handbook, Syllabus + and Callista data.

07/12/2017 - Unit disestablished at FEC 5/17 Item 7.3.

This unit is one of the optional foundation units for the Master of Information Technology (MIT) and Master of Applied Information Technology (MAIT). It is also available as an elective for all FIT Masters.

At the completion of this unit students will be able to:

• understand object-relational database design;
• understand multi-dimensional database design;
• understand query optimisation and its impact on programming;
• understand the database management systems recovery, concurrency, and transaction management mechanisms;
• understand database trends and current research directions in database management;
• use design a complex database system; and
• use a database programming language to access a relational database system.

020303

This unit looks at the design and implementation issues of database management systems. Advanced database design using the object-relational approach and multi-dimensional database design are explored. Record, file and index structures are dealt with at the basic level. Higher level details of consistency, atomicity and durability are introduced along with modern trends in databases.

On-campus

Examination (3 hours): 60%; In-semester assessment: 40%

6

2 hrs lectures/wk, 2 hrs laboratories/wk

FIT

FIT9019 or FIT9003

Knowledge of relational database principles, including SQL