BICT students need to get permission from the unit coordinator to enrol in the online offering. The online offering is primarily reserved for students enrolled in courses that are available online (e.g. Diploma of ICT Professional Practice, Undergraduate Certificate in ICT Professional Practice). Online students will need to attend online tutorials.
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 |
Sustainable Development Goals
The Unit Coordinator has identified that this unit aligns with the following UN Sustainable Development Goals. We welcome your thoughts and feedback on the alignment of the unit with these goals.
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.
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.