School of Computing · ANU College of Systems and Society
This course is an introduction to relational databases and the general skills for designing and using them. Topics include the relational data model, SQL, data modelling tools such as the entity-relationship model, functional dependencies, and (de-)normalisation, query processing and optimisation, and potential social and economic impacts of database design, for instance through (in-)security. Current development of database systems based on models other than the relational (known asNoSQL databases) will be introduced at the end of the course.
In-class activities and quizzes
Learning outcomes 1, 2, 3, 4
Assignments
Learning outcomes 2, 3, 4
Final Exam
Learning outcomes 1, 2, 3, 4
Lectures and laboratory sessions plus self study to a total of 130 hours. Other Information More information may be available for enrolled students on the course website on Canvas
Fundamentals of Database Systems, R. Elmasri and S. Navathe, 7th Edition (Global Edition), Pearson, 2017 (recommended only, not prescribed).