Undergraduate LTU-CSE2DBF-2022
Database Fundamentals
$4,425 $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
- 18 Jul 2022
- 14 Nov 2022
QS RANKING 2022
21
Times Higher Education Ranking 2022
13
Subject details
- 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 normalization 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
- • 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
Textbook information is pending.
Next study term: 13 Nov 22 to 10 Feb 23
Textbook information is pending.
Related degrees
Undergraduate LAT-TEC-DEG-2022
Bachelor of Information Technology
Just added
- Software engineering
- Cloud analytics