Available in 2022
Course code

COMP1140

Units

10 units

Level

1000 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

PSB Singapore

  • Trimester 2 - 2022 (Singapore)

Callaghan

  • Semester 2 - 2022

Ourimbah


    Learning outcomes

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

    1. Design conceptual models encapsulating data requirements for business and organisational scenarios

    2. Convert conceptual models to logical data models

    3. Implement a database solution using contemporary database management systems (DBMS)

    4. Develop expertise in database languages (e.g. SQL) including the ability to develop sophisticated queries to extract information from large datasets

    5. Understand data security and data quality management


    Content

    1.    Conceptual Modelling with ER

    2.    Relational Model and ER to Relational Mapping

    3.    Schema Refinement with Normalization based on Functional Dependencies

    4.    Relational Algebra  

    5.    SQL

    6.    Database Transactions and Concurrency Control

    7.    Security, Authorisation and Access 


    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:

    General Course Requirements:

    • Computer Lab: There is a compulsory attendance requirement in this course. - Attendance/participation will be recorded in the following components: - Lab (Method of recording: All students’ attendance will be recorded using the myUON app.) All students must attend at least 80% of the Labs. You can check in using the app or advise the academic staff member at the commencement of the session if you need them to check in on your behalf. All students’ attendance will be recorded using the my UON app.
    • Tutorial: There is a compulsory attendance requirement in this course. - Attendance/participation will be recorded in the following components: - Tutorial (Method of recording: All students’ attendance will be recorded using the myUON app.) All students must attend at least 80% of the Tutorials. You can check in using the app or advise the academic staff member at the commencement of the session if you need them to check in on your behalf. All students’ attendance will be recorded using the my UON app.

    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

    Callaghan

    Computer Lab

    Face to Face On Campus 2 hour(s) per Week for Full Term

    Lecture

    Face to Face On Campus 2 hour(s) per Week for Full Term

    PSB Singapore

    Computer Lab

    Face to Face On Campus 2 hour(s) per Week for Full Term

    Lecture

    Face to Face On Campus 2 hour(s) per Week for Full Term

    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.