$1,037 $0
Your upfront cost: $0
Duration
12 weeks
Study method
100% Online
Available loans
- HECS-HELP
- FEE-HELP
Assessments
Subjects may require attendance
Prior study
Not required
Start dates
- 31 Jul 2023
The third university established in Victoria, La Trobe University has a diverse community of more than 38,000 students and staff. Its commitment to excellence in teaching and research prepares students to make a bold and positive impact in today's global community. La Trobe provides Open Universities Australia with its core tenets, entrepreneurship and sustainability.
Learn more about La Trobe.
Explore La Trobe courses.
QS Ranking 2023
20
Times Higher Education Ranking 2023
16
Need help?
Our student advisors are here to guide you with:
- Enrolling and eligibility
- Fee and loan information
- Credit and recognition for prior learning
Subject details
-
- • ER/EER modelling and transformation.
- • Normalisation.
- • Relational algebra.
- • SQL.
- • PL/SQL.
Others
Past La Trobe University students who have previously completed CSE4DBF (Database Fundamentals) are ineligible to enrol in this subject.
Additional requirements
No additional requirements
This subject starts with an overview of the architecture and management of database systems, and a discussion of different existing database models. The main focus includes relational database analysis, design, and implementation. This subject prepares students for subjects such as the final year industry project which require an understanding of database design and implementation. The students learn: relational algebra as the formal foundation of relational databases; relational conceptual design using an entity-relationship diagram; relational logical database design; foundation of normalisation; security and integrity; and SQL implementation of relational database queries. Students are required to design a database application that meets the needs of a system requirement specification, and to implement the system using a commercial standard database system such as ORACLE or POSTGRESQL. In addition, a selection of advanced topics in databases will be introduced and discussed.
- Final centrally scheduled exam (5 Hours) (3000 words equivalent) (60%)
- Assignment 1_Part 1 (200 words equivalent) (10%)
- Assignment 2 (400 words equivalent) (20%)
- Assignment 1_Part 2 (200 words equivalent) (10%)
For textbook details check your university's handbook, website or learning management system (LMS).