Availabilities:

Location Domestic International
China - Guangxi UST N/A
Term5
Coomera
Term1
Term1
Gold Coast
Term1,5
Term1,5
Melbourne N/A
Term1,5
Online
Term1,5
N/A
Papua New Guinea - IBSU Port Moresby N/A
Term1,5
Perth N/A
Term1,5
Sydney N/A
Term1,5

Unit Summary

Unit type

UG Coursework Unit

Credit points

12

Faculty/College

Faculty of Science and Engineering

Pre-requisites

ISYS1005 - Systems Analysis and Design

Anti-requisites

CSC00228 - Database Systems I

Unit aim

Provides the student with an overall understanding of database concepts and theory. Students will learn how to design and build a database, from data analysis to mapping a specific database model. The relational model is emphasised and introduced using structured queried language (SQL) for creating and manipulating databases.

Unit content

  1. Database fundamentals
  2. The relational database model
  3. Creating databases
  4. Database design
  5. Advanced database design
  6. Database administration and client server databases

Learning outcomes

Unit Learning Outcomes express learning achievement in terms of what a student should know, understand and be able to do on completion of a unit. These outcomes are aligned with the graduate attributes. The unit learning outcomes and graduate attributes are also the basis of evaluating prior learning.

On completion of this unit, students should be able to:
1 Write and execute SQL queries for a relational database
2 analyse business or application requirements and model solutions using entity relationship diagrams (ERD)
3 design a logical database which meets business, application and the security needs for a client/server application
4 design, develop, test and prove the functionality of a database

On completion of this unit, students should be able to:

  1. Write and execute SQL queries for a relational database
  2. analyse business or application requirements and model solutions using entity relationship diagrams (ERD)
  3. design a logical database which meets business, application and the security needs for a client/server application
  4. design, develop, test and prove the functionality of a database

Prescribed texts

  • Note: While the 7th edition of the following text is recommended, page numbers for the 6th edition are also provided in the study guide: Kroenke, DA & Auer, DJ, 2015, Database Concepts, 7th edn, Pearson Education, New Jersey, USA.

  • Prescribed text information is not currently available.
Prescribed texts may change in future teaching periods.