Database Fundamentals unit (KIT119)

Melbourne Study Centre, Ultimo Study Centre, Hobart, Launceston, Online

Introduction

In this unit you will develop basic skills in data modelling using relational data models and normalisation to ensure data integrity.

The unit introduces relational data models, normalisation techniques, and data integrity principles, while providing hands-on experience in designing databases and using Structured Query Language (SQL) to retrieve, analyse, and manage data. You will explore how organisations transform raw data into meaningful insights through data analytics, reporting, and visualisation techniques that support evidence-based decision-making.

Recognising the growing importance of data as a strategic organisational asset, the unit also examines modern data management practices including data warehousing, data lakes, data integration, and data governance. Contemporary topics such as data quality, privacy, security, ethical data use, regulatory compliance, and the role of data in business intelligence and artificial intelligence (AI) applications will be explored. By the end of the unit, you will be equipped with foundational skills to support data-driven organisations and contribute to digital transformation initiatives across a range of industries.

Summary

Unit name	Database Fundamentals
Unit code	KIT119
Credit points	12.5
College/School	Sciences and Engineering School of Information and Communication Technology
Discipline	Information & Communication Technology
Coordinator	Doctor Selvi Kannan
Available as an elective?	Yes
Delivered By
Level	Introductory

Availability

Location	Study period	Attendance options		Available to
Melbourne Study Centre	Semester 2
Ultimo Study Centre	Semester 2
Hobart	Semester 2
Launceston	Semester 2
Online	Semester 2

Note

Please check that your computer meets the minimum System Requirements if you are attending via Distance/Off-Campus.

Units are offered in attending mode unless otherwise indicated (that is attendance is required at the campus identified). A unit identified as offered by distance, that is there is no requirement for attendance, is identified with a nominal enrolment campus. A unit offered to both attending students and by distance from the same campus is identified as having both modes of study.

Key Dates

Study Period	Start date	Census date	WW date	End date
Semester 2	5/7/2026	27/7/2026	30/8/2026	24/10/2026

* The Final WW Date is the final date from which you can withdraw from the unit without academic penalty, however you will still incur a financial liability (refer to How do I withdraw from a unit? for more information).

Unit census dates currently displaying for 2026 are indicative and subject to change. Finalised census dates for 2026 will be available from the 1st October 2025. Note census date cutoff is 11.59pm AEST (AEDT during October to March).

About Census Dates

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

Field of Education	Commencing Student Contribution 1,3	Grandfathered Student Contribution 1,3	Approved Pathway Course Student Contribution 2,3	Domestic Full Fee 4
020303	$1,192.00	$1,192.00	not applicable	$2,919.00

• Available as a Commonwealth Supported Place
• HECS-HELP is available on this unit, depending on your eligibility³
• FEE-HELP is available on this unit, depending on your eligibility⁴

¹ Please refer to more information on student contribution amounts.
² Please refer to more information on eligibility and Approved Pathway courses.
³ Please refer to more information on eligibility for HECS-HELP.
⁴ Please refer to more information on eligibility for FEE-HELP.

If you have any questions in relation to the fees, please contact UniConnect or more information is available on StudyAssist.

Please note: international students should refer to What is an indicative Fee? to get an indicative course cost.

Teaching

Teaching Pattern	On-Campus Melbourne and Sydney teaching arrangements may differ and will be advised by your teaching team. On-Line teaching arrangements may differ and will be advised by your teaching team. On-Campus enrolments in Hobart and Launceston: Lectures (online): 2 hr/week  Tutorial (on computer lab and online): 2hr/week, from week 2. Self-study: 1hr/week (associated with weekly lecture).  For this unit, students are expected to attend lectures and on-campus classes and are expected to remain up-to-date with content delivered asynchronously online.
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.