Undergraduate - UnitFIT2077 - Database design

This unit entry is for students who completed this unit in 2012 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

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

Level	Undergraduate
Faculty	Faculty of Information Technology
Offered	Caulfield First semester 2012 (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 semi-structured database design and retrieval;
understand database trends and current research directions in database management.

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

FIT1004 or CSE2132 or equivalent

Prohibitions

CSE3000, FIT3118, FIT4038

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

http://www.infotech.monash.edu.au/units/fit2077.html