The Information Resource

Description

Investigates data representation and data retrieval, and update and archival mechanisms for a range of information types. Integration and connectivity issues associated with different information resource architectures are also explored. Concepts are illustrated using current Data Base Management System (DBMS) platforms.

Availability

Ourimbah

  • Semester 1 - 2015
  • Semester 1 - 2016

Callaghan

  • Semester 1 - 2015
  • Semester 1 - 2016

UoN Singapore

  • Trimester 2 - 2015 (Singapore)
  • Trimester 1 - 2016 (Singapore)

Learning Outcomes

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

2. Understand physical database design and implementation issues

3. Understand contemporary issues and emerging technologies such as On-Line Analytical Processing (OLAP), Data Warehouses and Object Databases

4. Have hands-on experience with a number of contemporary information management systems

Content

Topics will be selected from:

  1. Design, develop and implement a mid-scale relational databases for an application domain using a commercial-grade RDBMS
  • 3-Level Conceptual Structure of Database Systems.
  • Conceptual modelling with EER
  • Logical Database Design (EER - Relational mapping, Normalisation)
  • Database Implementation with SQL using a commercial-grade RDBMS
  1. Physical database design and implementation issues.
  • Data Storage: Techniques and methods
  • Indexes, and data structures B+ tree indexes
  • Overview of query processing
  1. Database Theory and Techniques
  • Transactions
  • Concurrency Control (Conflicts, Anomalies and review at least one Concurrency Control Protocol such as Strict 2PL)
  1. Contemporary issues and emerging technologies such as On-Line Analytical Processing (OLAP), Data Warehouses and Object Databases.
     

Assumed Knowledge

INFT2040

Assessment Items

Written Assignment: Assignment 1 - Database Design

Formal Examination: Final exam *

Written Assignment: Assignment 2 - OLTP Database Implementation

Written Assignment: Assignment 3 - Data Warehouses

* 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. - A mark of at least 40% in the Final Examination is required.

Contact Hours

UoN Singapore

Computer Lab

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

24 hours of Lectures and 24 hours of Computer Laboratories will be delivered in Block mode for part-time students at UoN Singapore.

Lecture

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