Database Systems
24 hours face to face + blended
One Semester or equivalent
Hawthorn
Available to incoming Study Abroad and Exchange students
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
04-August-2025
02-November-2025
02-November-2025
Last self-enrolment date
17-August-2025
Census date
31-August-2025
Last withdraw without fail date
19-September-2025
Results released date
09-December-2025
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 |
| TOTAL | 150 |
Assessment
| Type | Task | Weighting | ULO's |
|---|---|---|---|
| Portfolio | Individual | 40 - 60% | 1,2,3,4,5 |
| Portfolio | Group | 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.