Database Concepts and Modelling - 2016

This page is for past year, View 2017 unit details.

Unit summary


  • Level of Study: Undergraduate Level 2
  • Study load: 0.125 EFTSL
  • Delivery method: Fully Online
  • Prerequisites: Yes
  • Duration: 13 weeks
  • Government loans available: FEE-HELP, HECS-HELP
  • Availability for 2016: SP2 , SP4
  • Assessment: Assignment 1 - (20%-30%) , Assignment 2 - (20%-30%) - Learn more

Unit provided by

2016 Fees
Domestic 1,114.00
HECS 1,114.00
International 1,364.00

This unit extends the basic information technology skills gained in INF10006 to the development of a simple automated personal database update and retrieval system to solve a problem. This unit provides an understanding of the development and management of relational databases with emphasis on data modeling and conceptual database knowledge. The student acquires the foundation knowledge necessary to evaluating database management systems. Within this framework data information and corporate knowledge are distinguished. Highlighted are the importance of database security and recovery and the integral role of the Database Administrator (DBA). Advanced database concepts are explored, covering Distributed Database Management Systems (DDBMS), Object-Oriented DBMS and databases in electronic commerce.

At the completion of this unit students will be able to:

  1. Analyse and explain the basic goals and functions of databases, their applications and social impact
  2. Explain the significance of each stage of the database life cycle (DBLC)
  3. Apply relational database modelling techniques and principles for conversion and application into physical designs
  4. Develop a working relational database prototype using a specified DBMS tool.
  5. Explain the role of database administration and the importance of database security, backup and recovery.
  6. Demonstrate a basic knowledge of contemporary and evolving trends such as distributed database management systems (DDDBMS), data warehouses and object-oriented DBMS.
  7. Differentiate between the Structured and Object-Oriented approaches to systems analysis
  • Assignment 1 — (20%-30%)
  • Assignment 2 — (20%-30%)
  • Invigilated Exam — (40%-50%)
  • Online assessment — (10%-20%)
For more information on invigilated exams see Exams and results

Equivalent units

You cannot enrol in this unit if you have successfully completed any of the following unit(s) because they are considered academically equivalent:

  • CIS211 — Database Concepts and Modelling

Mandatory prerequisites

You must have successfully completed the following unit(s) before starting this unit:

If you have completed equivalent study at another university, please contact a Student Advisor for advice.

This unit addresses the following topics.

1Abstraction and modelling
2Entity-relationship modelling: entity types, relationship types and attribute types
3The relational data model
4Structured query language
5Concurrency control
6Database recovery and transaction management
7Database design, implementation, management
8Developments in database management systems

Each unit offered through OUA provides students with unit information that includes assessment topics and due dates, policy information and contact numbers for university support and academic staff. Study materials will also clearly outline each week's topic, readings, student activities and the format of all assessment.

This unit is a core requirement in the following courses:

This unit is part of a major, minor, stream or specialisation in the following courses:

This unit is an approved elective in the following courses:

This unit may be eligible for credit towards other courses:

  1. Many undergraduate courses on offer through OUA include 'open elective' where any OUA unit can be credited to the course. You need to check the Award Requirements on the course page for the number of allowed open electives and any level limitations.
  2. In other cases, the content of this unit might be relevant to a course on offer through OUA or elsewhere. In order to receive credit for this unit in the course you will need to supply the provider institution with a copy of the Unit Profile in the approved format, which you can download here. Note that the Unit Profile is set at the start of the year, and if textbooks change this may not match the Co-Op textbook list.

Textbooks are subject to change within the academic year. Students are advised to purchase their books no earlier than one to two months before the start of a unit.

Click on the titles of the listed books below to find out more:

Required textbooks

  • Database Systems : Design, Implementation, & Management


    ISBN: 9781305627482


    Supplier:Go to The Co-op Bookshop

  • Enquire online

    Need to ask a question that's best put down in words?
    Make an online enquiry.

    Enquire now

    Got a question?

    Get an answer from one of our friendly Student Advisors.