Skip to main content
Unit of study_

COMP9120: Database Management Systems

2024 unit information

This unit of study provides a conceptual and practical introduction to the use of common platforms that manage large relational databases. Students will understand the foundations of database management and enhance their theoretical and practical knowledge of the widespread relational database systems, as these are used for both operational (OLTP) and decision-support (OLAP) purposes. The unit covers the main aspects of SQL, the industry-standard database query language. Students will further develop the ability to create robust relational database designs by studying conceptual modelling, relational design and normalization theory. This unit also covers aspects of relational database management systems which are important for database administration. Topics covered include storage structures, indexing and its impact on query plans, transaction management and data warehousing. In this unit students will develop the ability to: Understand the foundations of database management; Strengthen their theoretical knowledge of database systems in general and relational data model and systems in particular; Create robust relational database designs; Understand the theory and applications of relational query processing and optimisation; Study the critical issues in data and database administration; Explore the key emerging topics in database management.

Unit details and rules

Managing faculty or University school:

Computer Science

Code COMP9120
Academic unit Computer Science
Credit points 6
Prerequisites:
? 
None
Corequisites:
? 
None
Prohibitions:
? 
INFO2120 OR INFO2820 OR INFO2005 OR INFO2905 OR COMP5138 OR ISYS2120. Students who have previously studied an introductory database subject as part of their undergraduate degree should not enrol in this foundational unit, as it covers the same foundational content
Assumed knowledge:
? 
Some exposure to programming and some familiarity with data model concepts

At the completion of this unit, you should be able to:

  • LO1. demonstrate a basic understanding of the design of database solutions to data management problems
  • LO2. understand the transaction concept and its role in transaction processing systems
  • LO3. demonstrate competence in the use of SQL
  • LO4. index databases and query optimisation.

Unit availability

This section lists the session, attendance modes and locations the unit is available in. There is a unit outline for each of the unit availabilities, which gives you information about the unit including assessment details and a schedule of weekly activities.

The outline is published 2 weeks before the first day of teaching. You can look at previous outlines for a guide to the details of a unit.

Session MoA ?  Location Outline ? 
Semester 1 2024
Normal evening Camperdown/Darlington, Sydney
Semester 2 2024
Normal evening Camperdown/Darlington, Sydney
Session MoA ?  Location Outline ? 
Semester 1 2020
Normal evening Camperdown/Darlington, Sydney
Semester 2 2020
Normal evening Camperdown/Darlington, Sydney
Semester 1 2021
Normal evening Camperdown/Darlington, Sydney
Semester 1 2021
Normal evening Remote
Semester 2 2021
Normal evening Camperdown/Darlington, Sydney
Semester 2 2021
Normal evening Remote
Semester 1 2022
Normal evening Camperdown/Darlington, Sydney
Semester 1 2022
Normal evening Remote
Semester 2 2022
Normal evening Camperdown/Darlington, Sydney
Semester 2 2022
Normal evening Remote
Semester 1 2023
Normal evening Camperdown/Darlington, Sydney
Semester 1 2023
Normal evening Remote
Semester 2 2023
Normal evening Camperdown/Darlington, Sydney

Modes of attendance (MoA)

This refers to the Mode of attendance (MoA) for the unit as it appears when you’re selecting your units in Sydney Student. Find more information about modes of attendance on our website.