units

FIT9003

Faculty of Information Technology

18 September 2017 22 November 2024
Monash University

Postgraduate - Unit

This unit entry is for students who completed this unit in 2014 only. For students planning to study the unit, please refer to the unit indexes in the the current edition of the Handbook. If you have any queries contact the managing faculty for your course or area of study.

print version

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, or view unit timetables.

LevelPostgraduate
FacultyFaculty of Information Technology
OfferedNot offered in 2014

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.

Outcomes

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 allow them 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:

  • undertake the functional modelling of processes and data for a business problem;
  • 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 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.

Assessment

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

Chief examiner(s)

Dr Rob Meredith

Workload requirements

Minimum total expected workload equals 12 hours per week comprising:

(a.) Contact hours for on-campus students:

  • 2 hours of lectures
  • One 2-hour studio

(b.) Study schedule for off-campus students:

  • Off-campus students generally do not attend lecture and tutorial sessions, however should plan to spend equivalent time working through the relevant resources and participating in discussion groups each week.

(c.) Additional requirements (all students):

  • A minimum of 8 hours independent study per week for completing lab and project work, private study and revision.

Prohibitions

CSE9002, BUS3112, BUS4112, IMS9001, IMS9003, GCO9804, BUS9003, BUS5071, FIT1004, FIT2010, FIT9012, FIT9019

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

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