COMP6240

Relational Databases

Credit: 6 units
Catalogue year: 2027
Recorded offerings: First Semester, Second Semester

Course information

This course is an introduction to relational databases and the general skills for designing and using them. The topics include the relational data model, SQL, entity-relationship model,functional dependencies,(de-)normalisation, relational algebra, query processing and optimisation, database transactions and security. To deepen the understanding of relational databases, the current industry development of database systems such as NoSQL databases will be introduced at the end of this course.

Requisite and Incompatibility

You are not able to enrol in this course if you have successfully completed COMP2400. Incompatible with COMP7240.

Learning Outcomes

Upon successful completion, students will have the knowledge and skills to:

Describe the basic concepts of the relational model and understand its mathematical foundation;

Connect database design with social and economic impacts including security, ethics, and Australian Privacy Principles.

Use SQL to define, query and manipulate a relational database, and describe principles of SQL query processing and optimisation.

Use data modelling concepts and practices to create, evaluate and communicate relational database designs, collaboratively and individually.

Compare the relational data model with alternative models.

Saved ANU Programs & Courses information, 2027. Future offerings are indicative. Checks use the saved requirements and your fictional academic record.

Saved requirements encoded for automatic checks. See your requirement checks for what can be decided.

Course library: sources, offering dates and related entries

Read the full published course information ↗

Who reviews permission requests?

Dr Leo Brandt is the fictional reviewer assigned to COMP6240 in this prototype. The selected course determines where a request goes.

Relational Databases

Course information

Make this part of your semester