Relational Database Management Systems (COMP5138)

UNIT OF STUDY

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. Objectives: 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 optimization; - Study the critical issues in data and database administration; - Explore the key emerging topics in database management.

Our courses that offer this unit of study

Further unit of study information

Classes

One 2 hour lecture and one 2 hour tutorial per week.

Assessment

Through semester assessment (50%), Final Exam (50%)

Faculty/department permission required?

No

Unit of study rules

Prerequisites and assumed knowledge

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

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

Prohibitions

COMP5015, INFO2820

Study this unit outside a degree

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.

Find a non-award course for this unit of study

Cross-institutional study

If you are from another Australian tertiary institution you may be permitted to underake cross-institutional study in one or more units of study at the University of Sydney.

Find a cross-institutional course for this unit of study