USQ Logo
The current and official versions of the course specifications are available on the web at https://www.usq.edu.au/course/specification/current.
Please consult the web for updates that may occur during the year.

CSC8450 Relational Database Systems

Units : 1
Faculty or Section : Faculty of Health, Engineering and Sciences
School or Department : School of Mathematics, Physics & Computing
Student contribution band : Band 2
Grading basis : Graded
Version produced : 17 May 2022

Requisites

Pre-requisite: CSC5090

Overview

The database is an integral and essential component of most IT systems and services, whether they be used in scientific, business, government, or other organisations. The efficient daily operation of an enterprise, its business logic and intelligence, and its long-term sustainability are all significantly dependent upon well designed and efficient databases. It is important for an IT professional to be able to design high quality databases, to be proficient in database query languages, and to know how to integrate databases in other components of technical systems.

This course focuses on the design and implementation of relational databases. Practical methodologies for data modelling and database design are examined in concert with the study of the relational database model. Subsequently the course addresses the effective retrieval of information from the database using query languages and leverages those skills to implement data-driven processes using stored functions and triggers. The course concludes with examining modern options to scale databases for massive data tasks. All the course materials, except the recommended textbooks, are available on StudyDesk. Students are expected to work with USQ-supplied virtual machines either over a fast internet connection, or on a powerful personal computer.

Course offers

Semester Mode Campus
Semester 1, 2022 On-campus Toowoomba
Semester 1, 2022 Online
Date printed 17 May 2022