This is one of a series of undergraduate units which have been introduced to provide service teaching in foundation IT areas to non-FIT faculties

This unit has been updated as part of a 2009 review and comparison of data with current Handbook, Syllabus + and Callista data.

07/12/2017 - Unit disestablished at FEC 5/17 Item 7.3.

This unit provides foundation studies in Systems Analysis and Design, Database Management and Database Systems Implementation. It is an undergraduate version of FIT9003. The unit complements FIT2066, FIT2067 and FIT3129 in providing foundation studies in the IT disciplines for non-FIT students.

The study of Systems Analysis and Design and Database Management are fundamental to an awareness and success 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 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.

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, and the use of SQL and other facilities provided by database management systems.

On-campus and Off-Campus Learning(OCL)

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

Minimum total expected workload equals 12 hours per week comprising:

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

(b.) Additional requirements (all students):

FIT

Completion of 24 points at level 2