Available in 2022
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.


Availability

Online

  • Semester 2 - 2022

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

Formal Examination: Final Examination *

* This assessment has a compulsory requirement.


Compulsory Requirements

In order to pass this course, each student must complete ALL of the following compulsory requirements:

Course Assessment Requirements:

  • Formal Examination: Minimum Grade / Mark Requirement - Students must obtain a specified minimum grade / mark in this assessment item to pass the course. - Students whose overall mark in the course is 50% or more, but who score less than 40% in the compulsory item and thus fail to demonstrate the required proficiency, will be awarded a Criterion Fail grade, which will show as FF on their formal transcript. However, students in this position who have scored at least 25% in the compulsory item will be allowed to undertake a supplementary 'capped' assessment in which they can score at most 50% of the possible mark for that item.

Contact hours

Online

Online Activity

Online 4 hour(s) per Week for Full Term

For the online version of this course, four hours per week is a minimum recommendation and may vary with individual student learning styles.

The University of Newcastle acknowledges the traditional custodians of the lands within our footprint areas: Awabakal, Darkinjung, Biripai, Worimi, Wonnarua, and Eora Nations. We also pay respect to the wisdom of our Elders past and present.