FIT9132 is one of the foundation units for the Master of Information Technology and Master of Business Information Systems degrees.

17/7/13 Correcting prohibition. Change of location. Additional mode of teaching. Effective Semester 1 2014.

15/08/13 Change the learning objectives to learning outcomes

9/09/13 - On behalf of CE, modified wording of objectives based on advice from Director Education Quality. Amended objectives to comply with AQF requirements.

7/07/2014 - Added FIT5132 as prohibition and Malaysia to locations.

10/08/2015 - Change the exam duration from 2 hours to 3 hours. The change will allow more challenging questions to be asked during the exam to reduce the number of HDs and Ds in the unit. For implementation in semester 1 2016.

FIT9132 is one of the foundation units for the Master of Information Technology and Master of Business Information Systems postgraduate students. It prepares students so that they will understand the theoretical and practical aspects of providing computer solutions to real world problems.

At the completion of this unit students should be able to:

• explain the motivations behind the development of database management systems;
• describe the underlying theoretical basis of the relational database model and apply the theories into practice;
• evaluate several design options and construct a database design;
• develop a database based on a sound database design;
• construct queries that meet user requirements;
• contrast the differences between non-relational database models and the relational database model.

020303

This unit will introduce the concept of data management in an organisation through relational database technology. Theoretical foundation of relational model, analysis and design, implementation of relational database using SQL will be covered.

On-campus and off-campus.

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

6

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

Maria Indrawan-Santiago