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. 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.
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, 5
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.
Fundamentals of Database Systems, R. Elmasri and S. Navathe, 7th Edition (Global Edition), Pearson, 2017