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.

CSC3400 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 : 23 May 2022

Requisites

Pre-requisite: CSC1401 or CIS1000
Enrolment is not permitted in CSC3400 if CIS2002 has been previously completed.

Overview

A key component of information systems is its database management system. These are widely used in scientific, business, government, and industrial organisations. It is important for a computing professional to understand the basic concepts of database systems, to be proficient in a database query languages, and to know the design principles of database systems. It is also important to be able to integrate a database in the context of data-driven web application.

This course covers the fundamental issues of the relational model, relational languages, database design and query processing. It starts with a structured overview of database systems, their history and application. The relational model is then covered in detail. Relational languages such as the relational algebra and calculus are discussed before introducing the SQL language. Then we cover the Entity-Relationship model and discuss how ER diagrams are translated to the relational model. Topics on database design principles in this course further include functional dependencies and normalization. Students will gain a good understanding of database design theory and principles and be able to develop database systems and application programs on a DBMS.

Course offers

Semester Mode Campus
Semester 1, 2022 On-campus Springfield
Semester 1, 2022 On-campus Toowoomba
Semester 1, 2022 Online
Semester 3, 2022 Online
Date printed 23 May 2022