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

Callaghan Campus

  • Semester 1 - 2015

Ourimbah

  • Semester 1 - 2015

UoN Singapore

  • Trimester 2 - 2015 (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

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