Back to Find Units Page

Unit of Study DATA2001 - Database Systems (2021)

Show me unit information for year

Unit Snapshot

Unit description

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. Introduction to relational databases 
  3. Creating databases 
  4. SQL scripts 
  5. Data modelling 
  6. Introduction to database web apps 
  7. Advanced database design 
  8. Client server databases 
  9. More web applications 
  10. Database administration and warehousing

Availabilities

Location Domestic International
China - Guangxi UST N/A
Session1,2,3
Gold Coast
Session1,3
Session1,3
Melbourne N/A
Session1,3
Online
Session1,3
N/A
Papua New Guinea - IBSU Port Moresby N/A
Session1
Perth N/A
Session1,3
Sydney N/A
Session1,3

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:

list and explain the terminology of the relational database model

analyse business information requirements using entity relationship diagrams (ERD)

analyse a data model (ERD) into a logical database design with normalised relations

design, develop, test and prove the functionality of a database

construct, write and execute SQL queries

explain the necessary steps to develop an effective physical database design

explain the main functions of database administration and data warehouses.

Prescribed learning resources

Prescribed Texts
  • No prescribed texts.

Prescribed Texts
  • No prescribed texts.

Prescribed Texts
  • No prescribed texts.

Prescribed Learning Resources may change in future Teaching Periods.