Unit Catalogue

Back to Unit Search

PRT534 - Relational Database Systems

2027

Sector

Higher Education

Discipline

Information Technology

Credit Points

Unit Level

500

Equivalent Units

Prerequisites

Incompatible

Coerequisites

Assumed Knowledge

Unit Description

This unit develops your competency in entity-relationship modelling, normalisation theory, and the implementation of relational database designs through complex SQL for data retrieval and manipulation. You will apply these skills within the constraints of real database systems, including conflicting stakeholder requirements, performance and scalability trade-offs, security, transaction management, and database administration. You will critically evaluate architectural and design decisions against competing constraints and justify your choices with reference to normalisation theory and system requirements. You will also assess the strengths and limitations of relational database approaches relative to alternative data paradigms.

Unit Learning Outcomes

1.	Design a coherent relational database architecture, implemented in SQL and grounded in normalisation theory and system requirements.
2.	Critically evaluate the relative merits of relational and alternative data paradigms for a given problem context, and formulate effective database design recommendations.
3.	Assess the ethical, security, governance risks, and professional standards involved in relational database designs.
4.	Exercise independent professional judgement and accountability for a defined body of technical work while contributing to and coordinating a collaborative database design project.
5.	Present database design decisions and their trade-offs in a form suited to technical or non-technical audience using clear, well-structured, evidence-based argument.

Assessment Overview

	Assessment Task	Value (of total mark)	Related Learning Outcome/s
1.	Individual Online Quiz (30 minutes)	10%	1,2
2.	Group Project Presentation (5 mins per student, 3-4 students in group)	40%	1,2,3,4,5
3.	Group Project Report (2000 words per student, 3-4 students in group)	50%	1,2,3,4,5

Unit Availability

Year	Semester	Att Mode	Location	Learning Method	Timetable*
2027	Semester 1	Internal	CDU Sydney	OLR	View
2027	Semester 1	Internal	Danala - Education and Community Precinct	OLR	View
2027	Semester 1	External	External Studies	OLR	View

* Timetable will be displayed in new tab or window depending on your browser's configuration; ensure Pop-ups are allowed for this site to view the timetable.

OLR: Internet access is required for this unit as students are required to access study materials provided on-line through Learnline. Please log into Learnline on the first day of each teaching period. For more information about Learnline, please click here.

Critical Dates

Important Dates for Students

Fee Information:
Fees and Payments
Student Services and Amenities Fees
2026 Domestic Unit Fees (PDF)
2026 Incidental Fees (PDF)