SIT772 - Database Fundamentals

Year:

2023 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.

Scheduled learning activities - campus

1 x 2 hour online class per week, 1 x 2 hour workshop per week, weekly drop-in sessions.

Scheduled learning activities - cloud (online)

Online independent and collaborative learning including optional scheduled activities as detailed in the unit site.

Note:

Students enrolled in  S470, S464, S479, S508, S506, S507, S737, S735, S770, S779, S739 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 will provide a solid foundation for the design, implementation, and management of relational database systems. Data modelling is introduced, focusing on entity-relationship (ER) modelling. The skills required to construct such ER diagrams will be explored, with a focus on ensuring that the semantics of the model match those of the real-world it is representing. The relational data model will be presented and the functionality it affords will be explored. The process of constructing, maintaining, and retrieving information from the database using SQL will be a focus of this unit.

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

Click on the fee link below which describes you: