Module Outline
Date retreived
22/07/2026 5:14 PM AWST
22/07/2026 5:14 PM AWST
Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.
Database Design 112
Database Design 112
Module
National Code
State Code
51531
51531
DTWD Status
Approved
Approved
State Implementation and Classification
Approved Date
Field of Education
Nominal Hours
51
Description
To introduce techniques used for the analysis and
design of relational database systems.
To develop students competency in designing and
implementing relational database systems.
To introduce the major concepts of a Database
Management System.
design of relational database systems.
To develop students competency in designing and
implementing relational database systems.
To introduce the major concepts of a Database
Management System.
No information
Evidence Guide
Internal Assessment 100%
Assignment 1 30%
Develop a database to involve several relations
designed from E-R diagrams and consequent normalised
relations and manipulated with SQL over a full range
of processes.
Mid-Semester Test 40%
Short answer questions with focus on definition of
terms covered in database architecture and design.
Short case studies requiring use of design tools and
methodology - including E-R diagrams, normalisation
of relations and Relational Algebra done with SQL.
Assignment 2 30%
Development of a database project.
Requirements: System documentation User manual Design development
Demonstration of functions.
Assignment 1 30%
Develop a database to involve several relations
designed from E-R diagrams and consequent normalised
relations and manipulated with SQL over a full range
of processes.
Mid-Semester Test 40%
Short answer questions with focus on definition of
terms covered in database architecture and design.
Short case studies requiring use of design tools and
methodology - including E-R diagrams, normalisation
of relations and Relational Algebra done with SQL.
Assignment 2 30%
Development of a database project.
Requirements: System documentation User manual Design development
Demonstration of functions.
Elements and Performance Criteria
No information
No information
Associated Qual/Courses
| State Code | National Code | Title | Type |
|---|---|---|---|
| 6204 | Computer Applications | Accredited course |