Availabilities:

Not currently available in 2015

Unit Summary

Unit type

PG Coursework Unit

Credit points

12

AQF level

9

Level of learning

Intermediate

Former School/College

Former School of Business and Tourism

Pre-requisites

Information Systems Analysis & Design (to be advised)

Anti-requisites

CSC00228 - Database Systems I

Unit aim

This unit will provide students with an overall understanding of database concepts and theory. Students will learn the steps required to design and build databases and the key elements required to manage and maintain databases in an enterprise.

Unit content

  • Database fundamentals
  • Data and information analysis tools and techniques
  • Entity Relationship modelling and business rules
  • Logical database design
  • Relational databases
  • Physical database design
  • Client-Server Databases
  • Database Security
  • Data Warehousing
  • Data and database administration

Learning outcomes

Unit Learning Outcomes express learning achievement in terms of what a student should know, understand and be able to do on completion of a unit. These outcomes are aligned with the graduate attributes. The unit learning outcomes and graduate attributes are also the basis of evaluating prior learning.

GA1: , GA2: , GA3: , GA4: , GA5: , GA6: , GA7:
On completion of this unit, students should be able to: GA1 GA2 GA3 GA4 GA5 GA6 GA7
1 list and explain the terminology of the relational database model
2 model business information requirements
3 understand the processes used to translate data models into a logical database design with normalised relations
4 List the essential elements of testing strategies needed to test and prove the functionality of a database
5 describe the steps to develop a physical database design
6 explain the key managerial functions for effective administration of an enterprise’s databases
7 describe the key elements of an effective database and data security strategy

On completion of this unit, students should be able to:

  1. list and explain the terminology of the relational database model
    • GA4:
  2. model business information requirements
    • GA1:
    • GA2:
    • GA4:
    • GA6:
  3. understand the processes used to translate data models into a logical database design with normalised relations
    • GA1:
    • GA4:
  4. List the essential elements of testing strategies needed to test and prove the functionality of a database
    • GA1:
    • GA4:
  5. describe the steps to develop a physical database design
    • GA1:
    • GA4:
  6. explain the key managerial functions for effective administration of an enterprise’s databases
    • GA1:
    • GA4:
    • GA6:
  7. describe the key elements of an effective database and data security strategy
    • GA1:
    • GA4: