Available in 2017, 2018

Course handbook

Description

This course provides students with theoretical knowledge and practical skills in the use of databases and database management systems in information technology applications. The conceptual model, logical design, physical design and implementation of relational databases are covered. Contemporary issues and emerging technologies such as On-Line Analytical Processing (OLAP) and Data Warehouses are discussed.


Availability2017 Course Timetables

WebLearn GradSchool

  • Trimester 2 - 2017
  • Trimester 2 - 2018

Callaghan

  • Trimester 2 - 2017
  • Trimester 2 - 2018

Learning outcomes

On successful completion of the course students will be able to:

1. Evaluate the role of database management systems in information technology applications within organisations;

2. Recognise and use various conceptual models, logical design methods and tools for developing databases;

3. Derive a physical design for a database from its logical design;

4. Implement a database solution to an information technology problem using a commercial RDBMS.

5. Program using the SQL data definition and SQL query languages.

6. Recognise the value of and understand the problems associated with the use of procedural language extensions to SQL.

7. Understand contemporary emerging technologies such as On-Line Analytical Processing (OLAP) and Data Warehouses.


Content

  1. The role of databases and database management systems.
  2. Database models.
  3. Conceptual modelling with EER
  4. Logical design of databases.
  5. Physical design of databases.
  6. SQL query language.
  7. Procedural language extensions to SQL.
  8. Contemporary issues and emerging technologies such as On-Line Analytical Processing (OLAP) and Data Warehouses.

Assumed knowledge

INFO6001


Assessment items

Written Assignment: Assignment 1 - Requirements Gathering & Conceptual Database Design

In Term Test: Class Test - SQL

Written Assignment: Assignment 2 - Database Implementation

Written Assignment: Assignment 3 - Data Warehouse, OLAP & Business Intelligence

Formal Examination: Final Examination


Contact hours

Callaghan

Computer Lab

Face to Face On Campus 2 hour(s) per Week for Full Term

Lecture

Face to Face On Campus 2 hour(s) per Week for Full Term

WebLearn GradSchool

Computer Lab

Online 2 hour(s) per Week for Full Term

Computer Laboratory can incorporate a practical session or tutorial.

Lecture

Online 2 hour(s) per Week for Full Term