Course Title: Advanced Database Systems

Part A: Course Overview

Course Title: Advanced Database Systems

Credit Points: 12

Course Code




Learning Mode

Teaching Period(s)


City Campus


620H Business IT and Logistics


Sem 2 2006,
Sem 2 2007,
Sem 2 2008,
Sem 2 2009,
Sem 2 2010

Course Coordinator: Arthur Adamopoulos

Course Coordinator Phone: +61 3 9925 5782

Course Coordinator

Pre-requisite Courses and Assumed Knowledge and Capabilities

ISYS2038 - Business Information Systems Development
ISYS1010 - Systems Analysis

Course Description

Advanced database systems deals with current and emerging database technologies which enable us to handle complex applications. This course extends on material covered in previous courses and provides a comprehensive understanding of data modeling techniques and issues, relational databases and SQL queries, and emerging database technologies and issues.

Objectives/Learning Outcomes/Capability Development

At the conclusion of this course, you should develop the following capabilities:
- Ability to present your solution to problems in oral and written forms
- Ability to design database systems that will satisfy the relevant requirements
- Ability to solve problems collaboratively in groups

At the conclusion of this course, you should be able to:
- Understand data modeling concepts and issues.
- Have a good understanding of current modeling techniques.
- Understand how to translate a conceptual data model to a relational model.
- Have a competence in current database languages.

Overview of Learning Activities

In order to develop the stated course capabilities, you are expected to actively participate in the following learning activities:
- Regular attendance and active participation in scheduled classes.
- Reading of course notes and other assigned reading materials.
- Satisfactory completion of designated tasks.

While a minimum attendance standard is not compulsory in this course, satisfactory completion of the program is required. Most students will find that regular class attendance is needed to achieve the necessary standard to pass this course.

Overview of Learning Resources

Lecture notes and associated material, and reference books.

Overview of Assessment

The assessment for this course is on the basis of the satisfactory completion of assignments and class tests.
Should the course coordinator deem that variation to the assessment tasks is needed, then this will be discussed with the class and will only proceed with documented consent of 75 percent of the class.