COMPX323-21A (HAM)

Advanced Database Concepts

15 Points

Edit Header Content
Division of Health Engineering Computing & Science
School of Computing and Mathematical Sciences
Department of Computer Science


Edit Staff Content





Placement/WIL Coordinator(s)


Student Representative(s)

Lab Technician(s)



You can contact staff by:

  • Calling +64 7 838 4466 select option 1, then enter the extension.
  • Extensions starting with 4, 5, 9 or 3 can also be direct dialled:
    • For extensions starting with 4: dial +64 7 838 extension.
    • For extensions starting with 5: dial +64 7 858 extension.
    • For extensions starting with 9: dial +64 7 837 extension.
    • For extensions starting with 3: dial +64 7 2620 + the last 3 digits of the extension e.g. 3123 = +64 7 262 0123.
Edit Staff Content

Paper Description

Edit Paper Description Content
This paper provides an introduction to the advanced features of database management systems. Students will learn to use and manipulate advanced features, and to understand and explore the technical background of large database management systems. They will have hand-on practice in using these features to create, query and maintain a database using the Oracle system.
Edit Paper Description Content

Paper Structure

Edit Paper Structure Content

The objective of this paper is to provide students with in-depth knowledge and hands-on experience of a modern corporate relational database system. COMPX323 is taught through weekly lectures and tutorials, which will run mostly in an integrated fashion.

Topics covered in the lecture programme, tutorials and project will include:

  • Advanced database design (Entity-Relation model and relational schema)
  • Database Design Quality
  • Advanced data retrieval (SQL)
  • Indexing for faster data access
  • Big data and No-SQL databases
Edit Paper Structure Content

Learning Outcomes

Edit Learning Outcomes Content

Students who successfully complete the paper should be able to:

  • have the required skills for quality database design for large, complex data sets
    Linked to the following assessments:
  • have the skills for querying large complex data sets
    Linked to the following assessments:
  • have the skill for optimising database queries to make them run efficiently
    Linked to the following assessments:
  • have knowledge of web-based and alternative DB options (no-SQL and mobile)
    Linked to the following assessments:
Edit Learning Outcomes Content
Edit Learning Outcomes Content


Edit Assessments Content

Marks for completed work will be posted on Moodle for you to check and ensure that they have been recorded correctly. If there is any discrepancy in your marks, inform the lecturer.

Ensure you keep all complete coursework until you have received your final grade. The completed coursework will be required if you need to have your grade reviewed.

Edit Additional Assessment Information Content

Assessment Components

Edit Assessments Content

The internal assessment/exam ratio (as stated in the University Calendar) is 100:0. There is no final exam. The final exam makes up 0% of the overall mark.

The internal assessment/exam ratio (as stated in the University Calendar) is 100:0 or 0:0, whichever is more favourable for the student. The final exam makes up either 0% or 0% of the overall mark.

Component DescriptionDue Date TimePercentage of overall markSubmission MethodCompulsory
1. Weekly quizzes
  • Online: Submit through Moodle
2. Small test
5 Mar 2021
9:00 AM
  • In Class: In Lecture
3. Test 1
1 Apr 2021
10:00 AM
  • In Class: In Lecture
4. Test 2
14 May 2021
9:00 AM
  • In Class: In Lecture
5. Project
3 Jun 2021
10:00 AM
  • Hand-in: In Lab
Assessment Total:     100    
Failing to complete a compulsory assessment component of a paper will result in an IC grade
Edit Assessments Content

Required and Recommended Readings

Edit Required Readings Content

Required Readings

Edit Required Readings Content
There are no required textbooks for this paper. Reading material will be made available on Moodle.
Edit Required Readings Content

Recommended Readings

Edit Recommended Readings Content

There are no recommended textbooks for this paper. Reading material will be made available on Moodle.

A good textbook is"Database Systems: The Complete Book" by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom.

Edit Recommended Readings Content

Other Resources

Edit Other Resources Content

Computing resources

There will be a lab made available R Block for use by COMPX323A students to complete the project for this paper.

The lab is open for class use during normal working hours. Outside of these hours, you will need authorisation for after hours access. A Cardax authorisation form can be obtained from the Computer Science administrators. You may use the facilities during the lab session you signed up for. Sessional assistants will be available to assist you. You should not log on during the times that another class is scheduled to use the laboratory even if there are machines not being used. You are advised to check the laboratory schedule posted on the laboratory door for the available times.

Panopto Recordings

All lectures will be recorded and made available. However, many interactive discussions and practice sessions will have best learning outcomes when students attend in person.

Mini Lecture Videos

Selected topics will be introduced using video mini lectures. You are required to be familiar with these before attending the lectures following the publication of the videos, as these lectures will focus on student work and practicing the skills that have been introduced in the mini lecture video.

Flipped classroom and Integrated Lectures

In these lectures the typical lecture and homework elements of a course are reversed. Short video lectures are viewed by students at home before the class session, while in-class time is devoted to exercises, projects, or discussions.

Edit Other Resources Content

Online Support

Edit Online Support Content
Online support is provided through Moodle.
Edit Online Support Content


Edit Workload Content
Contact Hours:
  • Lectures:24
  • Tutorials/Labs:12 (may be integrated with lectures and in mini lecture videos)
  • Test:1 small + 2 normal

Non Contact Hours (average student):

  • Quizzes:12
  • Project:16
  • Mini lecture videos: up to 12
  • Reading/Revision:24
  • Studying for Tests:24

This is a very rough guideline; the number of hours you spend and the way you allocate those hours will depend very much on your individual background and aptitudes.

Edit Workload Content

Linkages to Other Papers

Edit Linkages Content


Prerequisite papers: COMPX223 or COMP219 and one of COMPX201, COMPX202, COMPX221, COMPX241, COMPX242, COMP203, COMP204, COMP258, COMP241 or COMP242




Restricted papers: COMP329

Edit Linkages Content