Faculty of Information Technology

Skip to content | Change text size

print version

Monash University Handbook 2011 Undergraduate - Unit

6 points, SCA Band 2, 0.125 EFTSL

Refer to the specific census and withdrawal dates for the semester(s) in which this unit is offered.

FacultyFaculty of Information Technology
OfferedCaulfield Summer semester A 2011 (Day)
Gippsland Second semester 2011 (Off-campus)


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.


At the completion of this unit students will have -
A knowledge and understanding of:

  • the purpose of requirements specification, of functional modelling of processes and data, and of the database concept;
  • the relational database model;
  • how to apply integrity constraints and business rules to a system design and implementation based around an enterprise level database management system.
Developed attitudes that enable them to:
  • understand business information systems as the implementation of company policies and objectives;
  • respect the points of view of both technical and business actors in the system development process.
Developed the skills to:
  • develop functional models of processes and data of the business problem scenario;
  • design and implement a database;
  • implement integrity constraints and business rules in a database;
  • write queries in SQL to maintain and use a relational database.
Demonstrated the communication and teamwork skills necessary to:
  • communicate requirements for business functionality in terms of data required, management of that data and its processing;
  • work co-operatively in a professional systems development team.


Examination (3 hours): 70%; In-semester assessment: 30%

Chief examiner(s)

Dr Shyh Wei Teng

Contact hours

2 hrs lectures/wk, 2 hrs laboratories/wk


Completion of 24 points at level 2


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

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