COMP2400/COMP6240 - Relational Databases

Welcome to Comp2400/Comp6240 in 2012.

• 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

  • Structured Query Language (SQL)

  • Entity-Relationship Model

  • Functional Dependencies

  • (De-)normalisation

  • Relational Algebra

  • Query Processing and Optimisation

  • Database Transactions and Security

  • Current Development of Database Systems (NoSQL and MapReduce)
  
  

• Textbook:

  Fundamentals of Database Systems, 6th edition, Elmasri and Navathe, Addison-Wesley, 2011