An examination of the issues required to design and maintain large and complex databases is important for those who wish to pursue a career as a database designer and programmer, data architect or research advanced issues in the database area. Knowledge of latest database design methodology and implementation, including their physical storage structures, their relationship to transaction loadings are vital. Latest issues of database management systems are also are key areas of knowledge for those working in or researching database management.

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 is a core third level unit in the Bachelor of Information Technology and Systems (BITS) major in Systems Development. It can also be taken as an elective by other FIT students who meet the prerequisite requirements. Students undertaking a Systems Development major benefit from an advanced understanding of database design and implementation issues.

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

• understand object-relational database design;
• understand multi-dimensional database design;
• understand semi-structured database design;
• understand query optimisation and its impact on programming;
• understand database trends and current research directions in database management;

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. Semi-structured database design and retrieval along with current trend of database design are introduced.

On-campus

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

2 hrs lectures/wk, 2 hrs laboratories/wk

David Taniar