ABOUT THIS SUBJECT
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. The students learn: relational algebra as the formal foundation of relational
databases; relational conceptual design using an entity-relationship diagram; relational logical database
design; security and integrity; and SQL implementation of relational database queries. Students will also
learn advanced normalization theory and the techniques to remove data anomalies and redundancies. In
this subject, 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.
Page 3 of 10
SUBJECT INTENDED LEARNING OUTCOMES (SILOs)
Upon successful completion of this subject, you should be able to:
1 Design a relational database using an ER or EER diagram and use a transformation process to
change the ER or EER diagram to a relational database design.
2 Evaluate database design in terms of data anomalies and redundancies by applying the appropriate
normalization techniques. 3 Implement database systems using SQL and advanced PL/SQL including stored procedures and
triggers. 4 Explain the underlying model of relational database operations using relational algebra. 5 Evaluate the possible risks and ethical and social considerations relevant to designed systems.
LEARNING ACTIVITY SCHEDULE
Week Learning Activity Contact
hours 1 Lecture – Overview – Databases Concepts and Terminologies 2
Lecture – Relational Model, Data Structure and Data Integrity 1 2 Lecture – ER Modelling (Concepts) + Problems 11
Laboratory – Database concepts and terminology. Simple ER
modelling
2 3 Lecture – Relational Table Transformation 1
Lecture – EER Modelling and Transformation 1
Laboratory – ER Modelling and Transformation 2 4 Lecture – Normalization 11
Laboratory – ER Transformation, EER modelling and
Transformation.
2 5 Lecture – Data Manipulation using Relational Algebra 11
Laboratory – Normalization 2 6 Lecture – SQL 11
Laboratory – Relational Algebra + SQL 2 7 Lecture – SQL 1
Laboratory – SQL 2 8 Lecture – SQL 1
Page 4 of 10
Catch up lecture 1
Laboratory – SQL 2 9 Lecture – Stored Procedures 11
Laboratory: SQL 2
10 Lecture – Stored Functions 1
Lecture – Triggers 1
Laboratory: Stored Procedures and Stored Functions 2
11 Lecture – Triggers 1
Lecture – Advanced Triggers 1
Laboratory – Triggers 2
12 Lecture – Revision 11
Laboratory – Advanced Triggers 2 Total 45
*Timetable details are available at http://www.latrobe.edu.au/students/timetables. Students should also
regularly check this subject’s LMS site for updated information.
