Database Concepts - 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: SP2 , SP3 , SP4
  • Availability for 2018: SP2 , SP3 , SP4
  • Assessment: Assignment 1 (20%) , Assignment 2 (30%) - Learn more

Unit provided by

2017 Fees
Domestic 1,131.00
HECS 1,131.00
International 1,381.00

Databases and database technology are having a major impact on the growing use of computers. They play a critical role in almost all areas where computers are used.

This unit is an introduction to the principles, use, and applications of database systems. It assumes no previous knowledge of databases or database technologies. Topics include: an introduction to relational database systems, the relational database model and entity-relationship model, SQL (Structured Query Language), relational design, and advanced topics such as the enhanced entity-relationship model, object-oriented model, and SQL in web-based applications.

Upon successful completion of this unit you should be able to:

  1. explain the fundamentals of database modeling and design, and implementation of a simple database application
  2. apply fundamental database concepts including analysing, designing, defining, constructing and manipulating relational database systems
  3. model data as relations
  4. use SQL as a data definition language and as a data manipulation language and formulate queries for specific users’ information needs
  5. define views and formulate queries on views
  6. use functional dependency concepts in relational database design and derive well-designed database schemas
  7. use conceptual modeling mechanisms such as entity-relationship diagrams to design a database schema
  8. design and implement database solutions for various application areas and to build queries for users’ needs, based on analysis of data modeling problem specifications
  9. analyse data modeling problem specifications and derive alternative conceptual models that represent the problem in different perspectives leading to alternative database designs.
  • Assignment 1 (20%)
  • Assignment 2 (30%)
  • Invigilated Exam (50%)
For more information on invigilated exams see Exams and results

Recommended prerequisites

You are recommended to have completed the following unit(s) or have equivalent knowledge before starting this unit:

This unit addresses the following topics.

1Introduction to databases
2Basic relational modelling
3Basic entity-relationship modelling
4Basic SQL programming
5Relational modelling and design
6Relational database design
7Advanced ER modelling
8Advanced SQL programming
9Post-Relational databases

This unit is delivered using the following methods and materials:

Instructional Methods

  • Audio/Video conferencing
  • Discussion Forum/Discussion Board
  • Embedded Multimedia
  • Online assignment submission
  • Podcasting/Lecture capture
  • Standard Media
  • Streaming Multimedia
  • Web links

Online materials

  • Audio/Video - Streaming
  • FAQs
  • Printable format materials
  • Resources and Links

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.

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

There are no required textbooks for this unit.

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.