Database Systems

INF20010 12.5 Credit Points Hawthorn, Sarawak Available to incoming Study Abroad and Exchange students

Duration

  • One Semester or equivalent

Contact hours

  • 48 Hours

On-campus unit delivery combines face-to-face and digital learning.

2022 teaching periods

Hawthorn

Higher Ed. Semester 2

Dates:
1 Aug 22 - 30 Oct 22

Results:
6 Dec 22

Last self enrolment:
14 Aug 22

Census:
31 Aug 22

Last withdraw without fail:
16 Sep 22


Corequisites

Nil

Aims and objectives

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.
 
Students who successfully complete this unit will be able to:
 
1 Explain how a relational database management system facilitates transaction management, and concurrency.
2 Develop a concurrent, multi-user business application using stored procedures, stored functions, triggers and a form based host application
3 Explain the need for and the fundamentals of data warehousing, ETL processes, data mining and business intelligence systems
4 Demonstrate the ability to design, build and implement a simple data warehouse system
5 Communicate effectively as a professional and function as an effective leader or member of a team