Relational Databases and Warehouses
Course Level Undergraduate
Area/Catalogue
INFS 4019
Course Level
Undergraduate
Offered Externally
Yes
Note: This offering may or may not be scheduled in every study period. Please refer to the timetable for further details.
Course ID
154341
Unit Value
4.5
University-wide elective course
No
Timetable/s
The 2025 timetable is
not yet available.
Course owner
UniSA STEM
Course Alert: This course is no longer available for enrolment
Course aim
To design and query relational databases and data warehouses.
Course content
The relational model and database constraints;
Data management and retrieval using SQL;
Database conceptual design;
Database logical design;
Data warehouse architecture and components;
Star and snow flake schemas;
the Multidimensional model;
the Relational model for OLAP;
Data warehouse design;
Data upload and update; and
Reporting and analysis.
Textbook(s)
Jukic, N 2020, Database Systems: Introduction to Databases and Data Warehouses, 2nd edition
Prerequisite(s)
Nil
Corequisite(s)
Nil
Teaching method
| Component | Duration | ||
|---|---|---|---|
| INTERNAL, MAWSON LAKES | |||
| Lecture (Some lectures are with demonstrations) | 2 hours x 13 weeks | ||
| Computer Practical | 1 hour x 12 weeks | ||
| INTERNAL, CITY WEST | |||
| Lecture (Some lectures are with demonstrations) | 2 hours x 13 weeks | ||
| Computer Practical | 1 hour x 12 weeks | ||
| EXTERNAL, MAWSON LAKES, ONLINE | |||
| External (On-line materials, on-line interactions with these material, weekly on-line computer practicals in a virtual machine environment, online interactions with the course coordinator and with other students, including through virtual workshops. ) | N/A x N/A | ||
Note: These components may or may not be scheduled in every study period. Please refer to the timetable for further details.
Assessment
Assignment, Examination, Test/Quiz
Fees
EFTSL*: 0.125
Commonwealth Supported program (Band 2)
To determine the fee for this course as part of a Commonwealth Supported program, go to:
How to determine your Commonwealth Supported course fee. (Opens new window)
Fee-paying program for domestic and international students
International students and students undertaking this course as part of a postgraduate fee paying program must refer to the relevant program home page to determine the cost for undertaking this course.
Non-award enrolment
Non-award tuition fees are set by the university. To determine the cost of this course, go to:
How to determine the relevant non award tuition fee. (Opens new window)
Not all courses are available on all of the above bases, and students must check to ensure that they are permitted to enrol in a particular course.
* Equivalent Full Time Study Load. Please note: all EFTSL values are published and calculated at ten decimal places. Values are displayed to three decimal places for ease of interpretation.
Course Coordinators
UniSA STEM
