Courses & Units
Database Fundamentals 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 DVC - Education |
| Discipline | University Pathways |
| Coordinator | Shoshanna Rudov-Clark |
| Available as an elective? | No |
| Delivered By | Third Party(ies): UP Education |
Availability
| Location | Study period | Attendance options | Available to | ||
|---|---|---|---|---|---|
| Hobart | IPC Semester 3 | On-Campus | International | ||
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 |
|---|---|---|---|---|
| IPC Semester 3 | 14/10/2024 | 4/11/2024 | 6/12/2024 | 24/1/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 2024 are indicative and subject to change. Finalised census dates for 2024 will be available from the 1st October 2023. 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,118.00 | $1,118.00 | not applicable | $2,648.00 |
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 UConnect 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.
Requisites
Mutual Exclusions
You cannot enrol in this unit as well as the following:
KIT119Teaching
| 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. |
Links | Booktopia textbook finder |
|---|
The University reserves the right to amend or remove courses and unit availabilities, as appropriate.