Database Fundamentals unit (XPD119)

Introduction

This unit will familiarise you with the fundamental concepts of database design and implementation techniques to define, construct and query a database. In this unit you will develop basic skills in data modelling using relational data models and normalisation to ensure data integrity. You will learn how to transform a data model into a relational database design as well as effectively mine data using the structured query language (SQL). You will explore a range of data visualisation techniques to be able to address organisation information requests. Essential requirements for secure data management to ensure data privacy and other legal responsibilities will also be covered including data mining, data lakes, and data warehousing.

Summary

Unit name	Database Fundamentals
Unit code	XPD119
Credit points	12.5
College/School	Academic Division Learning Teaching Performance
Discipline	University Pathways
Coordinator	Ms Cassie Yang
Available as an elective?	No
Delivered By	Third Party(ies): UP Education
Level	Introductory

Availability

Specific information on 2027 unit availability will be available in August

Learning Outcomes

• Develop database designs using relational data modelling, normalisation, and entity-relationship diagrams
• Implement and administer secure databases using a database management system
• Apply SQL commands to mine data from databases and data visualisation techniques to address organisation information needs
• Explain the privacy and legal requirements associated with managing and storing data

Fee Information

2027 fee information will be available in August.

Requisites

Mutual Exclusions

You cannot enrol in this unit as well as the following:

KIT119

Teaching

Teaching Pattern	1 lectorial in week 1 weekly 2 hour tutorials on campus
Assessment	Data visualisation Report (20%)|Database Implementation (20%)|Database Design (30%)|Module and Tutorial Exercises (30%)
Timetable	View the lecture timetable | View the full unit timetable

Textbooks

Required	Required readings will be listed in the unit outline prior to the start of classes.

The University reserves the right to amend or remove courses and unit availabilities, as appropriate.