Course Title: Advanced Database

Part A: Course Overview

Course Title: Advanced Database

Credit Points: 12

Course Code




Learning Mode

Teaching Period(s)


City Campus


620H Business Info Technology


Sem 2 2006,
Sem 2 2007

Course Coordinator: Arthur Adamopoulos

Course Coordinator Phone: +61 3 9925 5782

Course Coordinator

Course Coordinator Location: 108.17.07

Pre-requisite Courses and Assumed Knowledge and Capabilities

INTE2044 - Networks and Operating Systems
ISYS1040 - Systems Analysis and Design 2

Course Description

To extend on material covered in previous subjects and provide a comprehensive understanding of current database technologies, techniques and issues.

Objectives/Learning Outcomes/Capability Development

Upon completion of this subject, students will:

• Be able to design a database without errors.
• Be able to implement a database in SQL to a commercial standard, involving complex business rules.
• Be able to implement database server side program logic.
• Be able to install and configure a commercially used database – from scratch.
• Be able to configure and implement databases in relation to distribution and web server applications.

Overview of Learning Activities

To achieve the objectives listed above, this course requires the student to participate in various learning activities. These activities comprise the following:

• Attendance at, and note-taking during, scheduled lectures
• Attendance at, and participation in, scheduled workshops
• Reading of distributed subject notes and articles
• Completion of designated systems analysis, design and programming tasks

Overview of Learning Resources

Lecture notes, tutorial notes and text books.

Overview of Assessment

The assessment for this subject is on the basis of the satisfactory completion of a set of practical assignments, and passing a written examination.

1.Practical Assignmentstotal value ..... 50 %

2.Written examination total value ..... 50 %

To pass the subject, students must gain at least a pass in both the practical work and in the written examination. There is one exam, which will be held at the end of semester.