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%
  
  

  ---