Overview

This unit focuses on key Relational Database Management Systems constructs and concepts required to design and implement a multi-user database application. Transaction management and its properties such as Atomicity, Consistency, Isolation, Durability (ACID) is the key focus of this unit. Students will also learn about the design, implementation and population of a data warehouse via an Extract, Transform and Load (ETL) process.

Teaching Periods
Location
Start and end dates
Last self-enrolment date
Census date
Last withdraw without fail date
Results released date
Semester 2
Location
Hawthorn
Start and end dates
29-July-2024
27-October-2024
Last self-enrolment date
11-August-2024
Census date
31-August-2024
Last withdraw without fail date
13-September-2024
Results released date
03-December-2024

Learning outcomes

Students who successfully complete this unit will be able to:

  • Explain how a relational database management system facilitates transaction management, and concurrency
  • Implement a concurrent, multi-user business application using stored procedures, stored functions, triggers and a form based host application
  • Explain the need for and the fundamentals of data warehousing, ETL processes, data mining and business intelligence systems
  • Demonstrate the ability to design, build and implement a simple data warehouse system
  • Communicate effectively as a professional and function as an effective leader or member of a team

Teaching methods

Hawthorn

Type Hours per week Number of weeks Total (number of hours)
Face to Face Contact (Phasing out)
Lecture
2.00 12 weeks 24
Face to Face Contact (Phasing out)
Tutorial Labs
2.00 12 weeks 24
Unspecified Learning Activities (Phasing out)
Independent Learning
8.50 12 weeks 102
TOTAL150

Assessment

Type Task Weighting ULO's
PortfolioIndividual 40 - 60% 1,2,3,4,5 
PortfolioGroup 40 - 60% 1,2,3,4,5 

Content

  • Database Objects and the Data Dictionary
  • Data Independence through Views
  • Transactions and Concurrency
  • Client server systems
  • Data Warehousing, Data Mining
  • PL/SQL
  • Cursors
  • Stored Procedures/ functions
  • Triggers
  • XML
  • ​Non-standard database systems

Study resources

Reading materials

A list of reading materials and/or required textbooks will be available in the Unit Outline on Canvas.