units

FIT9019

Faculty of Information Technology

12 April 2013 18 June 2013

Postgraduate - Unit

print version

6 points, SCA Band 2, 0.125 EFTSL

Refer to the specific census and withdrawal dates for the semester(s) in which this unit is offered, or view unit timetables.

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)

Dr Maria Indrawan-Santiago

Contact hours

2 hrs lectures/wk, 2 hrs laboratories/wk

Prohibitions

CSE9002

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

http://www.infotech.monash.edu.au/units/fit9019/