Database Management 1

10 Units

Modern enterprises rely on the efficient storage and management of data. An organisation’s data provides information that is vital for its day-to-day existence. Corporate data structures can also be formed to serve as a knowledge repository for the organisation. These provide a basis for strategic decisions and enhance competitive advantage.

This course provides the foundational knowledge of database systems and their implementation with elementary programming skills. The course covers both the theoretical content and the practical implementation of database requirements for organisations. It presents the basics of information storage and management, from the conceptual modelling of an organisation’s data requirements using the relational model, through to the implementation of these requirements with tools such as SQL and techniques such as normalisation. It also addresses the practical issues of security and concurrency in data transactions. It introduces elementary programming techniques.

Faculty Faculty of Engineering and Built Environment
School School of Electrical Engineering and Computing
Availability Trimester 1 - 2018 (Callaghan)
Trimester 1 - 2018 (Online)
Learning Outcomes

On successful completion of this course, students will be able to:

  1. Be familiar with fundamental relational database concepts including entity relationship diagrams, data normalisation and relational operators;
  2. Design, develop and implement a mid-scale relational databases for an application domain using a commercial-grade RDBMS
  3. Design and implement physical database based on logical database representation
  4. Understand system implementation issues such as data views, data independence, indexing, security and transaction management
  5. Be able to apply elementary programming skills.

Topics will generally include:

  • 3 Level Architecture
  • SQL Basics: DDL, DML
  • Conceptual Modelling: E/R
  • Normalisation (to BCNF)
  • Database Design and Case Studies
  • Theory of Relational Database Systems
  • Data Integrity
  • Introductory computer skills in a contemporary development environment
  • Overview of the issues in Transaction Processing within the business environment
  • Contemporary issues in Database Systems.
Assumed Knowledge Desktop computer competency as prescribed by the International Computer Driving Licence. (See Australian Computer Society at )
Assessment Items
  • Project: Assignment 1 - Database Project - Description and EER model
  • Quiz: Quiz - Class
  • Formal Examination: Formal Examination *
  • Project: Assignment 2 - Database Project - Logical and Physical Database Design
  • Project: Database Project - Physical Database Design

* This assessment has a compulsory requirement.

Contact Hours


Computer Lab

Face to Face On Campus 2 hour(s) per Week for Full Term


Face to Face On Campus 2 hour(s) per Week for Full Term


Computer Lab

Online 2 hour(s) per Week for Full Term
For the On-line version of the course, four hours per week is a minimum recommendation and may vary with individual student's learning style for on-line courses.


Online 2 hour(s) per Week for Full Term

Compulsory Requirements
  • Course Assessment Requirements: 1. Formal Examination: Minimum Grade / Mark Requirement - Students must obtain a specified minimum grade / mark in this assessment item to pass the course. (Students whose overall mark in the course is 50% or more, but who score less than 40% in the compulsory item and thus fail to demonstrate the required proficiency, will be awarded a Criterion Fail grade which will show as FF on their formal transcript. However, students in this position who have scored at least 25% in the compulsory assessment item will be allowed to undertake a supplementary 'capped' assessment in which they can score at most 50% of the possible mark for that item.)
Course Materials
  • Database Systems
Timetable 2018 Course Timetables for INFO6001
Got a question?

Contact us for advice on how to apply, enrol, or for more information.

Ready to start?

Once you’ve read our Application guide you’re ready to apply