Skip to main content
Unit of study_

Database Management Systems - COMP9120

Year - 2018

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.

Classes
Lectures, Tutorials, Project work

Assessment
Through semester assessment (50%) and Final Exam (50%)

Assumed knowledge
Some exposure to programming and some familiarity with data model concepts

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.

Details

Faculty: Engineering and Information Technologies

Semester 1

05 Mar 2018

Department/School: Information Technologies
Study Mode: Normal (lecture/lab/tutorial) day
Census Date: 31 Mar 2018
Unit of study level: Postgraduate
Credit points: 6.0
EFTSL: 0.125
Available for study abroad and exchange: No
Faculty/department permission required? No
Location
Camperdown
Faculty: Engineering and Information Technologies

Semester 2

30 Jul 2018

Department/School: Information Technologies
Study Mode: Normal (lecture/lab/tutorial) day
Census Date: 31 Aug 2018
Unit of study level: Postgraduate
Credit points: 6.0
EFTSL: 0.125
Available for study abroad and exchange: No
Faculty/department permission required? No
Location
Camperdown
Courses that offer this unit

Non-award/non-degree study If you wish to undertake one or more units of study (subjects) for your own interest but not towards a degree, you may enrol in single units as a non-award student. Cross-institutional study If you are from another Australian tertiary institution you may be permitted to undertake cross-institutional study in one or more units of study at the University of Sydney.

To help you understand common terms that we use at the University, we offer an online glossary.