units

FIT9019

Faculty of Information Technology

Postgraduate - Unit

This unit entry is for students who completed this unit in 2013 only. For students planning to study the unit, please refer to the unit indexes in the the current edition of the Handbook. If you have any queries contact the managing faculty for your course or area of study.

print version

6 points, SCA Band 2, 0.125 EFTSL

To find units available for enrolment in the current year, you must make sure you use the indexes and browse unit tool in the current edition of the Handbook.

LevelPostgraduate
FacultyFaculty of Information Technology
OfferedCaulfield First semester 2013 (Evening)
Caulfield Second semester 2013 (Day)

Synopsis

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.

Outcomes

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.

Assessment

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

Chief examiner(s)

Contact hours

2 hrs lectures/wk, 2 hrs laboratories/wk

Prohibitions

CSE9002

Additional information on this unit is available from the faculty at: