FIT3118 - Database design and administration

Leader: David Taniar

Offered

Caulfield Second semester 2008 (Day)

Synopsis

This unit looks at the design and implementation issues of database management systems. 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.

Objectives

On the successful completion of this subject students will be able to:

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

Assessment

Examination (2 hours): 60%
Assignment work: 40%

Contact hours

2 hour lectures/week, 2 hour lab classes/week

Prerequisites

FIT1004 or CSE2132 or equivalent

Prohibitions

CSE3000