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.
Additional source review: awaiting review. Published wording is shown below.
Saved requirements encoded for automatic checks. These are prototype interpretations, not ANU decisions or degree-completion checks.
Requisite and Incompatibility
You are not able to enrol in this course if you have successfully completed COMP2400. Incompatible with COMP7240.
Referenced entries (2)
Links and code mentions retain their original context above. They may describe options, prerequisites or exclusions.
- COMP2400 · 2027 · saved source not linked
- COMP7240 · 2027 · saved source not linked
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.
Published offerings
Future offerings are indicative. Only recognised 2027 sessions with a published class number are offered in the enrolment demo.
| Year | Session | Class number | Class start date | Last day to enrol | Census date | Class end date | Mode Of Delivery | Class Summary |
|---|---|---|---|---|---|---|---|---|
| 2027 | First Semester | 5102 | 22 Feb 2027 | 01 Mar 2027 | 31 Mar 2027 | 28 May 2027 | In Person | N/A |
| 2027 | Second Semester | 10105 | 26 Jul 2027 | 02 Aug 2027 | 31 Aug 2027 | 29 Oct 2027 | In Person | N/A |
| 2028 | First Semester | 6686 | 21 Feb 2028 | 28 Feb 2028 | 31 Mar 2028 | 26 May 2028 | In Person | N/A |
| 2028 | Second Semester | 11057 | 24 Jul 2028 | 31 Jul 2028 | 31 Aug 2028 | 27 Oct 2028 | In Person | N/A |
Complete offering text
ANU utilises MyTimetable to enable students to view the timetable for their enrolled courses, browse, then self-allocate to small teaching activities / tutorials so they can better plan their time. Find out more on the Timetable webpage. The list of offerings for future years is indicative only. Class summaries, if available, can be accessed by clicking on the View link for the relevant class number. 2027 2028 First Semester Class number Class start date Last day to enrol Census date Class end date Mode Of Delivery Class Summary 5102 22 Feb 2027 01 Mar 2027 31 Mar 2027 28 May 2027 In Person N/A Second Semester Class number Class start date Last day to enrol Census date Class end date Mode Of Delivery Class Summary 10105 26 Jul 2027 02 Aug 2027 31 Aug 2027 29 Oct 2027 In Person N/A First Semester Class number Class start date Last day to enrol Census date Class end date Mode Of Delivery Class Summary 6686 21 Feb 2028 28 Feb 2028 31 Mar 2028 26 May 2028 In Person N/A Second Semester Class number Class start date Last day to enrol Census date Class end date Mode Of Delivery Class Summary 11057 24 Jul 2028 31 Jul 2028 31 Aug 2028 27 Oct 2028 In Person N/A
Source evidence (2 saved copies)
Matching copies share this record. Their original file locations and checksums are retained.
assets/Courses/Data Science/6000/Relational Databases/Relational Databases - ANU.html
Published ANU page · saved page URL
SHA-256: 8687959688303d560545dc2c7060b4d1c7dd5ffa4925f61062d6f141cdddad2cassets/Courses/Software Development/6000/Relational Databases/Relational Databases - ANU.html
Published ANU page · canonical URL in the saved page
SHA-256: 78d34c39c2cbb08969f23608bafaff8457ef01070acd289c10660fff37901360