Database Analysis and Design - 2016

To enrol in this unit, you must be accepted into a course from the provider. Read before you start
This page is for past year, View 2017 unit details.

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 2016: SP2
  • Assessment: Assignment - Group (10-20%) , Assignments - Individual (10-20%) - Learn more

Unit provided by

2016 Fees
Domestic 3,000.00
Domestic continuing 2,512.00
International 3,250.00
International continuing 2,762.00

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

All organisations need to store vast amounts of data gathered from both internal and external sources. Stored data must be able to be easily retrieved, aggregated and reported on. Stored data must be updated, deleted and added to. Relational Databases are the most common way of storing data about entities such as people, products, organisations and the transactions that occur between these entities. The most common problem with relational databases is a poor database schema which limits the storage, maintenance, retrieval and performance of the database. This unit focuses on appropriate database design techniques using Entity Relationship Diagrams and Normalisation techniques. Students design and build and critically analyse complex databases, then store, maintain and retrieve data using commercial relational database management tools. These skills are required by any persons who will interact with an existing database or will be involved in the design of new data storage and retrieval systems. Students are expected to review their design in the context of current trends as articulated in the academic literature.

Upon successfully completing this unit, students will be able to apply:

  1. coherent and advanced knowledge of database design
  2. database analysis and design fundamentals to the relational data model
  3. problem solving, design and conceptual data analysis methods to produce and document a logical data model
  4. coherent and advanced knowledge of trends in database design from the current literature
  • Assignment — Group (10-20%)
  • Assignments — Individual (10-20%)
  • Invigilated Exam — (40-60%)
  • Test — (20-30%)
For more information on invigilated exams see Exams and results

There are no prerequisites for this unit.

  • Broadband access

This unit addresses the following topics.

1Information in the organisation and business rules
2DBMS terminology and concepts
3The relational data model
4Structured Query Language
5Entity relational analysis
6Normalisation of data
7Data integrity
8Data warehousing

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 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

Got a question?

Get an answer from one of our friendly Student Advisors.