SIT772 - Database Fundamentals

Year:

2024 unit information

Enrolment modes: Trimester 1: Burwood (Melbourne), Waurn Ponds (Geelong), Online
Trimester 2: Burwood (Melbourne), Waurn Ponds (Geelong), Online
Trimester 3: Burwood (Melbourne), Waurn Ponds (Geelong), Online
Credit point(s): 1
EFTSL value: 0.125
Prerequisite:

Nil

Corequisite:

SIT771

Incompatible with:

SIT103

Study commitment

Students will on average spend 150 hours over the teaching period undertaking the teaching, learning and assessment activities for this unit.

This will include educator guided online learning activities within the unit site.

Scheduled learning activities - campus

1 x 2 hour online lecture per week, 1 x 2 hour practical experience (workshop) per week, weekly meetings.

Scheduled learning activities - online

Online independent and collaborative learning including 1 x 2 hour online practical experience (workshop) per week, weekly meetings.

Note:

Students enrolled in S406, S408, S434, S464, S470, S479, S506, S507, S508, S536, S538, S735, S737, S739, S770, S779, are not eligible to enrol in the following units:

SIT771 Object-Orientated Development
SIT772 Database and Information Retrieval
SIT773 Software Requirements Analysis and Modelling
SIT774 Web Technologies and Development

Content

This unit covers the fundamentals of designing, implementing, and managing relational database systems in industry-standard IT applications. It introduces data modelling, with a specific focus on entity-relationship (ER) modelling. Students will learn how to construct ER diagrams, ensuring that the model's semantics match those of the real-world object it represent. It also teaches how to construct, maintain, and retrieve information relational databases using SQL. Through real-world business case scenarios and project-based learning, students will gain skills to design, implement and manage databases.

Hurdle requirement

To be eligible to obtain a pass in this unit, students must meet certain milestones as part of the portfolio.

Unit Fee Information

Fees and charges vary depending on the type of fee place you hold, your course, your commencement year, the units you choose to study and their study discipline, and your study load.

Tuition fees increase at the beginning of each calendar year and all fees quoted are in Australian dollars ($AUD). Tuition fees do not include textbooks, computer equipment or software, other equipment or costs such as mandatory checks, travel and stationery.

Use the Fee estimator to see course and unit fees applicable to your course and type of place.

For further information regarding tuition fees, other fees and charges, invoice due dates, withdrawal dates, payment methods visit our Current Students website.