FIT1004 Database

This unit will provide an introduction to the concepts of database management. This will include planning, designing, using and implementing a data model using an enterprise-scale relational database system. Methods and techniques will also be presented to populate, retrieve, update and implement integrity features on data in the implemented database system.

Databases are so widely used today that they can be found in organisations of all sizes ranging from large government agencies and business corporations to small businesses and even home use. Every day activities such as using a credit card, purchasing a product at a supermarket via a scanning checkout and internet purchases, involve application programs which consult a database to carry out tasks such as verifying a credit limit, identifying a Universal Product Code, listing the range of products available or recording an internet purchase. FIT1004 will give you an understanding of the techniques which are used by IT professionals to design, implement and access data stored within a database. This 6 point unit is a core unit within the Bachelor of Information Technology and Systems and the Bachelor of Business Information Systems undergraduate degrees within the Faculty of IT.

Teaching

• two hours of lectures
• two hours of laboratory (requiring advance preparation)
• eight hours of self directed study - this will include reading and computer based activities.

Assessment

• Examination: 60%
• Two assignments: 40% of total

Prerequisites

Prerequisites

None

Corequisites

None

Prohibitions

BUS3112, CSE2132, CPE2005, CSE2138, CSE2316, CSE3180, CSE3316, GCO2815, IMS1907, MMS2801