Advanced Concepts in Database

Subject 615-330 (2009)

Note: This is an archived Handbook entry from 2009. Search for this in the current handbook

Credit Points: 12.50
Level: 3 (Undergraduate)
Dates & Locations:

This subject has the following teaching availabilities in 2009:

Semester 2, - Taught on campus.
Pre-teaching Period Start not applicable
Teaching Period not applicable
Assessment Period End not applicable
Last date to Self-Enrol not applicable
Census Date not applicable
Last date to Withdraw without fail not applicable

Lectures and laboratory-based seminars.

Timetable can be viewed here. For information about these dates, click here.
Time Commitment: Contact Hours: 24 lectures (three hours per week) and 11 laboratory-based seminars (two hours per week)
Total Time Commitment: 120 hours total time commitment.
Prerequisites:

A grade of at least H3 for 615-230 Database Concepts and successful completion of 62.5 points of second year level information systems subjects.

Corequisites: None
Recommended Background Knowledge: None
Non Allowed Subjects: None
Core Participation Requirements: It is University policy to take all reasonable steps to minimise the impact of disability upon academic study and reasonable steps will be made to enhance a student’s participation in the University’s programs. Students who feel their disability may impact upon their active and safe participation in a subject are encouraged to discuss this with the relevant subject coordinator and the Disability Liaison Unit.

Coordinator

Mr Sean Maynard
Subject Overview:

Topics will include database administration; physical database design and implementation; emerging database technologies; relational database issues (development, query processing and optimisation); and database and data management. Some of the department's industry partners may provide assistance in the subject's delivery. This subject builds upon students' understanding of topics such as logical database design and SQL.

At the completion of this subject, students should be able to:

  • develop the physical design required of a large database system;

  • implement a large database; and

  • manage large databases efficiently.

Objectives:

At the completion of this subject, students should be able to:

  • develop the physical design required of a large database system;

  • implement a large database; and

  • manage large databases efficiently.

Assessment:

Assigned project work expected to average six hours per week due during the semester (40%); a 3-hour written examination in the examination period (60%). Satisfactory completion of both project work and the examination is necessary to pass the subject.

Prescribed Texts: None
Breadth Options:

This subject potentially can be taken as a breadth subject component for the following courses:

You should visit learn more about breadth subjects and read the breadth requirements for your degree, and should discuss your choice with your student adviser, before deciding on your subjects.

Fees Information: Subject EFTSL, Level, Discipline & Census Date
Generic Skills:

Students should acquire and extend valuable, generic skills through solving the problems encountered throughout the subject. These include:

  • analytic and problem-solving skills;

  • application of theory to practice in IS database management;

  • written and oral communication skills; and

  • confidence to tackle unfamiliar problems.

Download PDF version.