Database Analysis and Design
Credit points
(Generally, 1 credit = 10 hours of classes and independent study.)
Location
Footscray Park
Online Real Time
VU Brisbane
VU Sydney
Prerequisites
Co-requisites
(Corequisite units must be studied concurrently with this unit)
Overview
This unit discusses the specialised skills for designing and using relational databases. It is a core unit in this advanced and applied IT course. The unit provides students with an in-depth knowledge of SQL relational data modelling, database design, and daily administration and deployment of the relational database.
Learning Outcomes
On successful completion of this unit, students will be able to:
- Abstract data requirements into data models using entity-relationship diagram and relational data model and design relational databases;
- Formulate efficient SQL queries to store, manipulate and transform data into useful information to users;
- Assess and rationalise database design with functional dependencies and normal forms;
- Propose and devise query optimisation, transaction and security management for relational database management systems; and
- Exhibit mastery of theoretical knowledge and practical skills relating to the Relational Data Model and Relational Database Management Systems.
Assessment
For Melbourne campuses
Assessment type: Laboratory Work | Grade: 20%
Laboratory submissions (10)
Assessment type: Project | Grade: 50%
Database design and analytics project with prestation and Q&A verification.
Assessment type: Case Study | Grade: 30%
Group database case study
Required reading
Required readings will be made available on VU Collaborate.
As part of a course
This unit is studied as part of the following course(s):