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


Availability2024 Course Timetables

Singapore PSB

  • Trimester 1 - 2024 (Singapore)

Callaghan

  • Semester 2 - 2024

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

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

Trimester 1 - 2024 (Singapore) - Singapore PSB

Computer Lab-1
  • Face to Face On Campus 2 hour(s) per week(s) for 11 week(s) starting in week 3
Lecture-1
  • Face to Face On Campus 2 hour(s) per week(s) for 12 week(s) starting in week 1

Semester 2 - 2024 - Callaghan

Computer Lab-1
  • Face to Face On Campus 2 hour(s) per week(s) for 11 week(s) starting in week 3
  • Compulsory Requirement: Students must attend 80% of sessions.
Lecture-1
  • Face to Face On Campus 2 hour(s) per week(s) for 12 week(s) starting in week 1

Course outline