Melbourne Study Centre, Ultimo Study Centre, Hobart, Launceston, Online
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
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 | KIT119 |
| Credit points | 12.5 |
| College/School | Sciences and Engineering School of Information and Communication Technology |
| Discipline | Information & Communication Technology |
| Coordinator | Ms Sumbal Maqsood |
| 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 |
|
|
|
|
- Key:
- On-campus
- Off-Campus
- International students
- Domestic students
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 | 20/7/2025 | 18/8/2025 | 7/9/2025 | 25/10/2025 |
* 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 2025 are indicative and subject to change. Finalised census dates for 2025 will be available from the 1st October 2024. Note census date cutoff is 11.59pm AEST (AEDT during October to March).
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,164.00 | $1,164.00 | not applicable | $2,780.00 |
- Available as a Commonwealth Supported Place
- HECS-HELP is available on this unit, depending on your eligibility3
- FEE-HELP is available on this unit, depending on your eligibility4
1 Please refer to more information on student contribution amounts.
2 Please refer to more information on eligibility and Approved Pathway courses.
3 Please refer to more information on eligibility for HECS-HELP.
4 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.