Available in 2024
Course code

INFO6001

Units

10 units

Level

6000 level

Course handbook

Description

Modern enterprises rely on the efficient storage and management of data. An organisation's data provides information that is vital for its day-to-day existence. Corporate data structures can also be formed to serve as a knowledge repository for the organisation. These provide a basis for strategic decisions and enhance competitive advantage.This course provides the foundational knowledge of database systems and their implementation with elementary programming skills. The course covers both the theoretical content and the practical implementation of database requirements for organisations. It presents the basics of information storage and management, from the conceptual modelling of an organisation's data requirements using the relational model, through to the implementation of these requirements with tools such as SQL and techniques such as normalisation. It also addresses the practical issues of security and concurrency in data transactions. It introduces elementary programming techniques.


Availability2024 Course Timetables

Callaghan

  • Trimester 1 - 2024

Singapore NAIHE

  • Trimester 1 - 2024

Online

  • Trimester 1 - 2024

Sydney Elizabeth Street

  • Trimester 1 - 2024

Learning outcomes

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

1. Master fundamental relational database concepts including entity relationship diagrams, data normalisation and relational operators

2. Design, develop and implement a mid-scale relational databases for an application domain using a commercial-grade RDBMS

3. Design and implement physical database based on logical database representation

4. Understand system implementation issues such as data views, data independence, indexing, security and transaction management

5. Apply elementary programming skills.


Content

Topics will generally include:

  • 3 Level Architecture
  • SQL Basics: DDL, DML
  • Conceptual Modelling: E/R
  • Normalisation (to BCNF)
  • Database Design and Case Studies
  • Theory of Relational Database Systems
  • Data Integrity
  • Introductory computer skills in a contemporary development environment
  • Overview of the issues in Transaction Processing within the business environment
  • Contemporary issues in Database Systems.

Assumed knowledge

Desktop computer competency as prescribed by the International Computer Driving Licence. (See Australian Computer Society at http://www.icdl.com.au/ )


Assessment items

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

Project: Assignment 2 - Database Project - Logical Database Design

In Term Test: Practical Test - Lab test on SQL

Project: Assignment 3 - Database Project - Physical Database Design

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 - Callaghan

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

Trimester 1 - 2024 - Singapore NAIHE

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

Trimester 1 - 2024 - Online

Computer Lab-1
  • Online 2 hour(s) per week(s) for 12 week(s) starting in week 2
  • For the On-line version of the course, four hours per week is a minimum recommendation and may vary with individual student's learning style for on-line courses.
Online Activity-1
  • Online 2 hour(s) per week(s) for 12 week(s) starting in week 1

Trimester 1 - 2024 - Sydney Elizabeth Street

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

Course outline