Monash University > Publications > Handbooks > Units

Leader(s): Gippsland - Suryani Lim

Offered

Gippsland Second semester 2009 (Day)
Gippsland Second semester 2009 (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, and the use of SQL and other facilities provided by database management systems.

Objectives

At the conclusion of the unit students will have the following knowledge.

1. Have an understanding of the purpose of requirements specification, of functional modelling of processes and data, and of the database concept.
2. Have an understanding of the relational database model.
3. Have developed the knowledge to allow them to apply integrity constraints and business rules to a system design and implementation based around an enterprise level database management system.

At the completion of the unit students will have been exposed to attitudes and beliefs consistent with exemplary professional practice in these areas. Specifically:

1. Have developed attitudes that understand business information systems as the implementation of company policies and objectives.
2. Have developed attitudes that respect the points of view of both technical and business actors in the system development process.

At the completion of the unit students should also have the skills to conscientiously undertake the following tasks.

1. The functional modelling of processes and data of the business problem scenario.
2. The skills to design and implement a database.
3. The skills to implement integrity constraints and business rules in a database.
4. The skills to write queries in SQL to maintain and use a relational database.

At the conclusion of the unit the students will have the ability to communicate requirements for business functionality in terms of data required, management of that data and its processing. They will have the communicative and management skills to work co-operatively in a professional systems development team.

Assessment

Practical Assignments: 30%
Examination: 70%

Contact hours

One x 2 hr lecture/week, One x 2 hr tutorial or laboratory session/week.

Prerequisites

24 points of second level study

Prohibitions

FIT1004, FIT9003, CSE9002, BUS3112, BUS4112, IMS9001, IMS9003, GCO9804, BUS9003, CSE4430, BUS5071
This unit is not available to any student enrolled in an FIT degree

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

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