units

FIT9019

Faculty of Information Technology

Skip to content | Change text size
 

print version

Monash University Handbook 2010 Postgraduate - Unit

6 points, SCA Band 2, 0.125 EFTSL

LevelPostgraduate
FacultyFaculty of Information Technology
OfferedCaulfield First semester 2010 (Evening)
Caulfield Second semester 2010 (Day)
Coordinator(s)Mr Manoj Kathpalia

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.

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.

Assessment

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

Chief examiner(s)

Dr Campbell Wilson

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/