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. 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, … For more content click the Read More button below.

Offerings

S1-01-CLAYTON-ON-CAMPUS

S1-FF-CLAYTON-FLEXIBLE

S2-01-CLAYTON-ON-CAMPUS

Rules

Enrolment Rule

Contacts

Chief Examiner(s)

Dr Dwi Rahayu

Notes

IMPORTANT NOTICE:
Scheduled teaching activities and/or workload information are subject to change in response to COVID-19, please check your Unit timetable and Unit Moodle site for more details.

Learning outcomes

On successful completion of this unit, you 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.

Teaching approach

Active learning

Assessment

1 - In-semester assessment

2 - Examination (2 hours and 10 minutes)

Scheduled and non-scheduled teaching activities

Tutorials

Workshops

Workload requirements

Workload

Learning resources

Required resources

Availability in areas of study

Business analytics
Data science
Software development