Special GPG 2/07 - title of unit changed for introduction in 1/2008.

Updated Contact Hours from 2hrs Lectures / 2 hrs Laboratory per week to 2 hrs Lectures / 2 hrs Studio per week. The change reflects the nature of the non-lecture contact with students, consisting of a mixture of computer-based and non-computer-based, individual and group tasks. This will ensure proper timetabling of the unit in the future.

30/11/2017 - Unit disestablished at FEC 5/17 Item 7.3.

This unit provides foundation studies in systems design, with a focus on data modelling as the means by which system design principles are conveyed. It complements FIT9004, FIT9005, and FIT9006, which provide other foundation studies in the disciplines covered by Information Technology. The study of Systems Design is fundamental to professional practice in the IT disciplines.

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.

020303

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.

On-campus and Off-Campus Learning(OCL)

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

Minimum total expected workload equals 12 hours per week comprising:

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

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

(c.) Additional requirements (all students):

FIT