INF20010 – Database Systems

INF20010     |       12.5 Credit Points       |       Location: Hanoi, Ho Chi Minh City

Duration                                             Contact hours

One Semester                                       48 hours

Prerequisites

Database Analysis and Design (INF10002)
and
Introduction to Programming (COS10009)

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

General Skills Outcome

• Teamwork skills
• Problem solving skills
• Analysis skills
• Communication skills
• Ability to tackle unfamiliar problems, and
• Ability to work independently