Availabilities:

Location Domestic International
Coffs Harbour Session 1 Session 1
Gold Coast Session 1 Session 1
Melbourne N/A Session 1
Online Session 1,  3 N/A
Papua New Guinea - IBSU Port Moresby Session 1 Session 1
Sydney N/A Session 1

Unit Summary

Unit type

UG Coursework Unit

Credit points

12

AQF level

7

Level of learning

Advanced

Former School/College

Former School of Business and Tourism

Pre-requisites

ISY00243 - Systems Analysis and Design

Unit aim

This unit will provide the student with an overall understanding of database concepts and theory. Students will learn how to design and build a database, from data analysis to mapping a specific database model. The relational model is emphasized and introduced using structured queried language (SQL) for creating and manipulating databases. Assignment work includes the analysis, design, and implementation of a database.

Unit content

1. Database fundamentals 
2. Introduction to relational databases 
3. Creating databases 
4. SQL scripts 
5. Data modelling 
6. Introduction to database web apps 
7. Advanced database design 
8. Client server databases 
9. More web applications 
10. Database administration and warehousing

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 using entity relationship diagrams (ERD)
3 translate a data model (ERD) into a logical database design with normalised relations
4 design, develop, test and prove the functionality of a database
5 formulate, write and execute SQL queries
6 describe the necessary steps to develop an effective physical database design
7 explain the main functions of database administration and data warehouses.

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

  1. list and explain the terminology of the relational database model
    • GA4:
    • GA6:
  2. model business information requirements using entity relationship diagrams (ERD)
    • GA1:
    • GA2:
    • GA4:
  3. translate a data model (ERD) into a logical database design with normalised relations
    • GA4:
  4. design, develop, test and prove the functionality of a database
    • GA1:
    • GA2:
    • GA4:
  5. formulate, write and execute SQL queries
    • GA4:
  6. describe the necessary steps to develop an effective physical database design
    • GA1:
    • GA4:
    • GA6:
  7. explain the main functions of database administration and data warehouses.
    • GA1:
    • GA4:
    • GA6:

Prescribed texts

  • Note: 7th edn is likely to become available near to beginning of Session 1. Page numbers are not provided in the study guide for the 7th edn.: Kroenke, DA & Auer, DJ, 2013, Database Concepts, 6th edn, Pearson Prentice Hall, New Jersey USA.

  • Kroenke, DA & Auer, DJ, 2013, Database Concepts, 6th edn, Pearson Prentice Hall, New Jersey USA. ISBN: 978-0132742924.
Prescribed texts may change in future teaching periods.