FIT9003 - Database systems design

Leader: Rob Meredith

Offered

Clayton Second semester 2007 (Day)
Gippsland Second semester 2007 (Off-campus)
Hong Kong Second semester 2007 (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 hours per week

Prohibitions

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