Database Analysis and Design (Previously INF20004 Database Concepts and Modelling) - 2017

Unit summary


  • Level of Study: Undergraduate Level 1
  • Study load: 0.125 EFTSL
  • Delivery method: Fully Online
  • Prerequisites: Yes
  • Duration: 13 weeks
  • Government loans available: FEE-HELP, HECS-HELP
  • Availability for 2017: SP1 , SP2
  • Availability for 2018: SP1
  • Assessment: Portfolio - Individual (100%)

Unit provided by

2017 Fees
Domestic 2,925.00
Domestic continuing 1,180.00
HECS 1,131.00
International 3,175.00
International continuing 1,430.00

Tuition fees are reduced for continuing registered SWI students.
Please login to view the applicable amount.

This unit describes how to deal with the data available to organisations from both internal and external sources, how data is stored and retrieved in ways which are useful and effective. Students are introduced to techniques of data modelling and database design as a means of analysing, understanding and recording data. Some of the key commercial database management tools are discussed along with tools for quick and easy data retrieval and visualisation. The unit also introduces students to how people and organisations can access, analyse and make use of data found in social media etc.

After successfully completing this unit, you will be able to:

  1. Explain the concepts of structured, semi-structured and unstructured data and how they are used by organisations
  2. Use data analysis methods to produce and document a logical data model
  3. Explain and demonstrate the key principles involved in good database design
  4. Design and use simple database systems using a commercial relational database and management system tools
  5. Work collaboratively in diverse groups.
  • Portfolio — Individual (100%)

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:

  • INF20004 — Database Concepts and Modelling

This unit addresses the following topics.

1Information in the organisation
2DBMS terminology and concepts
3The relational data model
4Structured Query Language
5Entity relational analysis
6Normalisation of data
7Data integrity
8Data warehousing
9Data normalisation
10Storage of semi-structured and unstructured data
11Querying semi-structured and unstructured data

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 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.
This unit does not have a prescribed textbook(s).

Enquire online

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

Enquire now

Ready to enrol?

Start studying this unit now.


Got a question?

Get an answer from one of our friendly Student Advisors.