Skip navigation
The Australian National University

Welcome to Relational Databases -- COMP2400/COMP6240

  • Course Lecturers:

    Qing Wang (course coordinator) and Mohammad Yamin

  • Course Information:

    • For COMP2400 students, it is available from here.
    • For COMP6240 students, it is available from the here.

  • Course Content:

    All the course materials (lecture slides, lab tutorials, handouts, assignments, supplementary read materials and etc.) will be available through Wattle this year.

  • Course Timetable:

    The lecture and lab/tutorial times will be available online at ANU Timetablelling before Semester 2 starts.

  • Course Topics:

    • Introduction to Database Systems
    • Relational Data Model
    • Entity-Relationship Model
    • Functional Dependencies
    • (De-)normalisation
    • Structured Query Language (SQL)
    • Relational Algebra
    • Query Processing and Optimisation
    • Database Programming
    • Database Transactions and Security
    • NoSQL Databases (Amazon's Dynamo, Google's BigTable, MongoDB and MapReduce)

  • Recommended Textbook:

    • Database systems: models, languages, design, and application programming, 6th edition, R. Elmasri and S. Navathe, Pearson, 2011

    This book has also been published under a different title:

    • Fundamentals of Database Systems, 6th edition, R. Elmasri and S. Navathe, Addison-Wesley, 2011

    Both versions have the same content, so either is fine. Older editions (4th or 5th editions) are also fine. The textbook is available from the Co-op bookshop, and some copies are available in the reserve section of the Hancock Library.

  • Assessment

    • Assignments 34%
    • SQL lab exam 12%
    • Quiz 4%
    • Final exam 50%

Updated:  18 June 2014 / Responsible Officer:   JavaScript must be enabled to display this email address. / Page Contact:   JavaScript must be enabled to display this email address. / Powered by: Snorkel 1.4