FIT9019 - Database technology

Leader(s): Dr Linda Dawson

Offered

Caulfield First semester 2009 (Evening)
Caulfield Second semester 2009 (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.

Objectives

At the completion of the unit, students will be expected to:

1. understand the motivations behind the development of database management systems.
2. appreciate the underlying theoretical basis of the relational database model and how this model may be implemented in practice
3. understand the differences between non-relational database models and the relational database mode
4. be able to apply logical and physical database design principles to a database implementation.
5. be conversant with Structured Query Language (SQL).
6. understand the processes involved in database administration, transaction management, concurrency control, restart and recovery.

Assessment

Assignments: 35%, Exam; 65%

Contact hours

2 hours of lectures/week, 2 hours of tutorials/week

Prerequisites

Must be enrolled in the MAIT

Prohibitions

CSE9002

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

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