Your upfront cost: $0
Subjects may require attendance
- 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
Times Higher Education Ranking 2023
Our student advisors are here to guide you with:
- Enrolling and eligibility
- Fee and loan information
- Credit and recognition for prior learning
Apply a database modelling technique using an ER and EER diagram, and use a transformation process to change these to a relational database design.
Identify the appropriate normalisation techniques for database design.
Implement a database system using SQL and apply the relevant knowledge in database management and administration.
Define the underlying model of relational database operations using relational algebra.
Identify the possible risks and ethical and social considerations relevant to a designed system.
- • ER/EER modelling and transformation.
- • Normalisation.
- • Relational algebra.
- • SQL.
- • PL/SQL.
Past La Trobe University students who have previously completed CSE4DBF (Database Fundamentals) are ineligible to enrol in this subject.
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).