Course Title: Design a Database

Part A: Course Overview

Program: C5148

Course Title: Design a Database

Portfolio: BUS

Nominal Hours: 50.0

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Course Code




Learning Mode

Teaching Period(s)


City Campus


650T TAFE Business

Face-to-Face or Internet

Course Contact: Chandra Nannegari

Course Contact Phone: 992 51657

Course Contact Email:

Course Description

The course provides students with fundamental knowledge of the development process for a database modelling. The modelling begins with the concept of determinants, covers data redundancy including anomalies, normal forms, then moves on to ER design, and then implements the design creating tables, relationships, writing queries, designing reports and forms.

The knowledge gained also includes understanding the concepts of data dictionary, indices, DBMS constraints, business rules, backup and recovery requirements.

Further, knowledge of security systems is provided to prevent unauthorised access to database application.

Pre-requisite Courses and Assumed Knowledge and Capabilities

Model Preferred Solutions with national code - ICAITAD046A and RMIT course code - COSC 5731C is a pre-requisite. This course has Nil Co-Requisites.

National Competency Codes and Titles

National Element Code & Title:

ICAITAD139A Design a Database


Access and security systems are designed

Data structures are designed

Database design is confirmed

Logical data model is developed

Queries, screens and reports are designed

Scope and functionality of database is determined

Learning Outcomes

Overview of Assessment

Assessment may incorporate a variety of methods including technical requirements documentation, homework and in class exercises, written tests, practical problem solving exercises and practical tests. Students are advised that they maybe be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met.