Available in 2024
Course code

COMP6140

Units

10 units

Level

6000 level

Course handbook

Description

This course provides students with theoretical knowledge and practical skills in the use of databases and database management systems. The conceptual and logical design and implementation of relational databases are covered.


Availability2024 Course Timetables

Online

  • Semester 2 - 2024

Learning outcomes

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

1. Design data models and execute database normalisation

2. Evaluate the role of database management systems

3. Identify and use contemporary logical design methods and tools for databases

4. Master database languages (e.g. SQL)

5. Implement a database solution to a computing problem

6. Develop sophisticated queries to extract information from large datasets

7. Maintain key aspects of data security and data quality management

8. Explore research aspects of databases and information management


Content

  • Data Modelling (ER Model and Conceptual Design)
  • Relational Algebra and Relational Calculus
  • SQL
  • Transaction Management and Concurrency Control
  • Schema Refinement, Functional Dependencies, Normalisation
  • Security and Authorisation
  • Database Administration  

Requisite

This course has similarities to INFT2040. If you have completed INFT2040 you cannot enrol in this course.


Assumed knowledge

Knowledge of and experience in programming


Assessment items

Project: Assignment 1: Database Project - Description and EER model

Project: Assignment 2: Database Project - Logical Database Design

Quiz: Practical Test - Lab test on SQL

Project: Assignment 3: Database Project - Physical Database Design

Online Open Book Formal Examination: Final Examination
Compulsory Requirement: Pass requirement 40% - Must obtain 40% in this assessment item to pass the course.


Contact hours

Semester 2 - 2024 - Online

Online Activity-1
  • Online 4 hour(s) per week(s) for 13 week(s) starting in week 1
  • For the online version of this course, four hours per week is a minimum recommendation and may vary with individual student learning styles.

Course outline