Monash University Handbook 2010 Postgraduate - Unit

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/