There is a more recent version of this academic item available.

Overview

This unit will provide an introduction to the concepts of database design and usage and the related issues of data management. You 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, … For more content click the Read More button below.

Offerings

NOV12-CLAYTON-ON-CAMPUS

S1-01-CLAYTON-ON-CAMPUS

S1-01-MALAYSIA-ON-CAMPUS

S2-01-CLAYTON-ON-CAMPUS

S2-01-MALAYSIA-ON-CAMPUS

Rules

Enrolment Rule

Contacts

Chief Examiner(s)

Dr Dwi Rahayu

Unit Coordinator(s)

Ms Golnoush Abaei

Notes

This unit is part of an Education Transformation Project in the Faculty of Information Technology.  

Learning outcomes

On successful completion of this unit, you should be able to:
1.

Apply the theories of the relational database model;

2.

Develop a sound relational database design;

3.

Implement a relational database based on a sound database design;

4.

Manage data that meets user requirements, including queries and transactions;

5.

Contrast the differences between non-relational database models and the relational database model;

6.

Develop programming structures within a database backend.

Teaching approach

Peer assisted learning

Assessment summary

This unit has threshold mark hurdles. You must achieve at least 45% of the available marks in the final scheduled assessment, at least 45% in total for in-semester assessments, and an overall unit mark of 50% or more to be able to pass the unit. If you do not achieve the threshold mark, you will receive a fail grade (NH) and a maximum mark of 45 for the unit.

Assessment

1 - Conceptual model

2 - Database design

3 - SQL creation

4 - Scheduled final assessment (2 hours and 10 minutes)

Scheduled and non-scheduled teaching activities

Applied sessions

Tutorials

Workshops

Workload requirements

Workload

Learning resources

Required resources

Recommended resources

Technology resources

Availability in areas of study

Advanced computer science
Software engineering