FIT9003 - Database systems design

Leader: Clayton - Yen Cheung; Gippsland - Manoranjan Paul

Offered

Caulfield First semester 2008 (Evening)
Clayton Second semester 2008 (Day)
Gippsland Second semester 2008 (Off-campus)
Singapore Second semester 2008 (Off-campus)

Synopsis

This unit is designed to introduce students to the fundamental concepts necessary for the analysis, design, use and implementation of business information systems using relational database management systems. The main topics covered include requirements elicitation, systems analysis and design informed by a lifecycle based methodology, motivation for the database approach to managing information, conceptual modelling, coverage of logical process and data models (hierarchical, network and relational data models), and the use of SQL and other facilities provided by database management systems.

Objectives

To develop student knowledge of the techniques for functional analysis of a business problem, requirements specification of a database application system, and planning, designing, implementing and manipulating a database within a methodological framework.

Assessment

Practical Assignments: 30%; Examination: 70%. Students must pass in both forms of assesment in order to pass the subject.

Contact hours

4 x contact hrs/week

Prohibitions

BUS3112, BUS4112, BUS5071, BUS9003, CSE4430, CSE9002, GCO9804, IMS9001, IMS9003