Database Analysis and Design - 2018

To enrol in this unit, you must be accepted into a course from the provider. Read before you start

Unit summary


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

Unit provided by

2018 Fees
Domestic 3,490.00
Domestic continuing 2,822.00
International 3,740.00
International continuing 3,072.00

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

This unit critically analyses methods of dealing with both internal and external data available to organisations. This includes data sourced from cloud and social networks.  Effective data usage must take into account efficient data storage and retrieval methodologies to realise potential organisational benefits. Students will apply data modelling techniques and data design strategies to complex problems to illustrate how to maximise the efficient storage and retrieval of organisational data.

Students are expected to review their design in the context of current trends as articulated in the academic literature.

Students who successfully complete this unit will be able to:

  1. Apply coherent and advanced knowledge on the use of structured, semi-structured and unstructured data by organisations to a complex business problem using appropriate business methods and tools
  2. Apply business fundamentals to the analysis, design and operation of a data structures using appropriate data modelling tools
  3. Critically analyse database design trends using the current academic literature
  4. Communicate proficiently in professional practice to a variety of audiences.
  • Portfolio — Individual (100%)

There are no prerequisites for this unit.

In order to enrol in this unit, you must be accepted into one of the following courses:

Please visit the course details page and read the Requirements tab for more information about eligibility.

This unit addresses the following topics.

1Data and Information management techniques
2Relational Database terminology and concepts
3Modelling with Entity-Relationship Diagrams
4Data Design Strategies
5Using local and cloud based solutions for data storage and retrieval
6Using Data Normalisation techniques to enhance data integrity and data maintenance
7Using SQL to manage and manipulate relational data
8Non-relational databases terminology and concepts
9Database Transactions Management
10Using Data Analytics and Analytic Tools for strategic decision making
11Using non-relational data for strategic decision making

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.