units

FIT4038

Faculty of Information Technology

12 April 2013 26 May 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 (Day)

Synopsis

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. Higher level details of consistency, atomicity and durability are introduced along with modern trends in databases.

Outcomes

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

  • understand object-relational database design;
  • understand multi-dimensional database design;
  • understand query optimisation and its impact on programming;
  • understand the database management systems recovery, concurrency, and transaction management mechanisms;
  • understand database trends and current research directions in database management;
  • use design a complex database system; and
  • use a database programming language to access a relational database system.

Assessment

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

Chief examiner(s)

Associate Professor David Taniar

Contact hours

2 hrs lectures/wk, 2 hrs laboratories/wk

Prerequisites

FIT9019 or FIT9003
Knowledge of relational database principles, including SQL

Prohibitions

FIT3118, CSE3000

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

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