Database Fundamentals

• • • ER/EER Modelling and Transformation
  • • Normalization
  • • 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 normalization; 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.

• One 3-hour examination (3,000-words equivalent) Hurdle requirement: To pass the subject, a pass in the examination is mandatory (60%)
• Assignment 1_Part 1 (200 words equivalent) (10%)
• Assignment 2 (400 words equivalent) (20%)
• Assignment 1_Part 2 (200 words equivalent) (10%)

Current study term: 17 Jul 22 to 14 Oct 22

Next study term: 13 Nov 22 to 10 Feb 23