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 … For more content click the Read more button below.
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.
Capstones provide students with a way of integrating and applying knowledge and skills gained throughout their course.
No
Academic progress review - Schedule A subject
No
Subject instances
To view instance specific details which include - Assessments, Class requirements and Subject instance coordinators - please select your preferred instance via the drop-down menu at the top right-hand side of this page.
Career ready
Work based learning (placement):No
Graduate capabilities
COMMUNICATION - Digital Capability
DISCIPLINE KNOWLEDGE AND SKILLS
INQUIRY AND ANALYSIS - Creativity and Innovation
INQUIRY AND ANALYSIS - Critical Thinking and Problem Solving
Subject intended learning outcomes
On successful completion you will be able to:
1.
Apply a database modelling technique using an ER and EER diagram, and use a transformation process to change these to a relational database design.
2.
Identify the appropriate normalization techniques for database design.
3.
Implement a database system using SQL and apply the relevant knowledge in database management and administration.
4.
Define the underlying model of relational database operations using relational algebra.
5.
Identify the possible risks and ethical and social considerations relevant to a designed system.
Enrolment rules
Special conditions
This subject is also available through Open Universities Australia (OUA)
