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

FIT9019 will be delivered in Peer Instruction mode in semester 1, 2013. Some marks need to be allocated to online quizzes and peer instruction participation. Current allocation of 35% for in-semester assessment will limit the amount of marks to be allocated for unit tests and assignment during the semester. Hence, allocation of marks for in-semester assessments is increased to 50%.

30/11/2017 - Unit disestablished at FEC 5/17 Item 7.3.

This is a core unit in the Master of Applied Information Technology (MAIT). It is a foundation unit and one of six core units required for the MAIT. It provides students with a postgraduate foundation unit in database and has been run for many years (it pre-dates FIT9003, which provides a less technological focus).

The unit is a core constituent of postgraduate courses which have been identified as congruent with Faculty strategic objectives.

At the completion of this unit students will:

• understand the motivations behind the development of database management systems;
• appreciate the underlying theoretical basis of the relational database model and how this model may be implemented in practice;
• understand the differences between non-relational database models and the relational database mode;
• be able to apply logical and physical database design principles to a database implementation;
• be conversant with Structured Query Language (SQL);
• understand the processes involved in database administration, transaction management, concurrency control, restart and recovery.

020303

Database concepts and models, relational database management systems, semantic data modelling, entities and entity relationship modelling, normalisation, user requirements specification, database specification. Storage media and data organisation, logical data structures: linear and non-linear. Physical database implementation, integrity, backup, recovery, security. Structured Query Language, database administration. Current topics; distributed database, data warehousing, Object-oriented database.

On-campus

Examination (2 hours): 50%; In-semester assessment: 50%

6

2 hrs lectures/wk, 2 hrs laboratories/wk

FIT