The unit is being introduced as part of the new BInfoTech degree and in the Data Science specialisation in the BCompSc degree being introduced in 2016.

November 2016: Add FIT1040 as alternative programming prerequisite for students in transition. Confirmed by CE, David Taniar.

25/9/2015 - Minor change to unit learning outcomes as per ADE email of 25/9/2015.

24/1/2017 - Minor change to Examination duration, effective S1 and S2, 2017

07/12/2017 - Updating prerequisites to include the new programming unit.

February 2018: Amendment to workload "Additional hours" so that it adds up to 12 hours/week.

20/9/2019: Admin - updating exam duration to include additional 10 minutes as per University requirement.

06/11/2019: Admin - adding Reasons for Change - CE Modified Workload/ContactHours (lectures changed into workshops and labs changed into tutorials) to support new version of the unit which will be conducted in Woodside building for 2020. This changes have been discussed with 2019 CE (Marc Cheong) on 5 November 2019. I will be the CE for the unit in S1 2020.

4/5/2020: As the MSA course 4307 Bachelor of Computer and Information Sciences is in teach-out, the MSA offering of this unit has been re-coded to FZA2094 effective Semester 2, 2020. These units will be managed by South Africa and therefore no separate Monatar entries will be made

17/09/2020 Admin: Update to include new assessment and teaching approach fields as per Handbook requirements.

15/02/2021: Change assessment regime following introduction of new University assessment guidelines and FLEX review/comments of 2020 offerings, date of implementation S1 2021

This is a core unit in the BInfotech degree and in the Data Science specialisation in the BCompSc. The unit provides students with knowledge for designing, creating and interrogating relational databases.

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

1. explain the motivations behind the development of database management systems;
2. describe the underlying theoretical basis of the relational database model and apply the theories into practice;
3. develop a sound database design;
4. develop a database based on a sound database design;
5. construct queries that meet user requirements;
6. develop a simple web-based interface for a database;
7. use data modelling and database development tools effectively.

020303

This unit will provide an introduction to the concepts of database design and usage and the related issues of data management. Students will develop skills in planning, designing, and implementing a data model using an enterprise-scale relational database system (Oracle). Methods and techniques will also be presented to populate, retrieve, update and implement integrity features on data in the implemented database system.

Students are required to have access to a copy of the textbook Coronel, C., & Morris, Steven, Database Systems: Design, Implementation, and Management (Version 12 or 13 is suitable).

Recommended resources

Technological requirements

On-campus

Peer-assisted learning In this unit, we plan to use a peer-assisted learning approach. To maximise the learning experience for students in this approach, students are expected to read the suggested sections from the textbook prior to attending the workshop sessions . The preparation prior to the workshop is CRUCIAL to the successful participation of students in peer-assisted learning during the workshop sessions.

The concepts and knowledge learnt through self-study prior to and during the workshop sessions will be emphasized and practised during the tutorial classes.

Examination (2 hours and 10 minutes): 50%; In-semester assessment: 50%

1. Workshop Exercise - 5% - ULO: 1,2,3,4,5,6,7
2. Assignment 1A: Conceptual Model: - 5% - ULO: 2, 3
3. Assignment 1B: Full Database Model and Implementation: - 15% - ULO: 2, 3, 4, 7
4. Assignment 2A: SQL Database Creation/Modification - 10% - ULO: 2, 4, 7
5. Assignment 2B: SQL Queries - 15% - ULO: 2, 4, 5, 7
6. End of semester examination - 50% - ULO: 1, 2, 3, 4, 5, 6, 7

Minimum total expected workload equals 12 hours per week comprising:

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

(b.) Additional requirements (all students):

Oracle database, SQL Developer , Response gathering system for the Peer Instruction.

One of FIT1040, FIT1045, FIT1053, FIT1048, FIT1051 or equivalent introductory programming unit