• Offered by Research School of Computer Science
  • ANU College ANU College of Engineering and Computer Science
  • Classification Transitional
  • Course subject Computer Science
  • Areas of interest Information Technology
  • Academic career PGRD
  • Course convener
    • Dr Qing Wang
  • Mode of delivery In Person
  • Co-taught Course
  • Offered in Second Semester 2014
    See Future Offerings

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.    

Learning Outcomes

Upon successful completion, students will have the knowledge and skills to:

On satisfying the requirements of this course, students will have the knowledge and skills to:

  1. Describe the basic concepts of the relational model and understand its mathematical foundation;
  2. Use the SQL language to define, query and manipulate a relational database;
  3. Apply conceptual database modelling methods such as entity-relationship model to design a relational database;
  4. Apply database design methods on functional dependencies and normal forms to evaluate the quality of a relational database design;
  5. Understand query processing and optimization, transaction and security management in a relational database management system.
  6. Understand the state of the art of database management systems, and big data management challenges (Amazon's Dynamo, Google's BigTable, MongoDB and MapReduce).





Other Information

More information may be available for enrolled students on the course website on Wattle

More information may be available for enrolled students on the course website at http://cs.anu.edu.au/courses/COMP2400/


Indicative Assessment

Quiz (4%); Assignments (34%); SQL Assessment (12%); Final Exam (50%)


The ANU uses Turnitin to enhance student citation and referencing techniques, and to assess assignment submissions as a component of the University's approach to managing Academic Integrity. While the use of Turnitin is not mandatory, the ANU highly recommends Turnitin is used by both teaching staff and students. For additional information regarding Turnitin please visit the ANU Online website.

Workload

33 one-hour lectures and 7 two-hour laboratory sessions


Prescribed Texts

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

Assumed Knowledge

COMP1100 or COMP1710 or INFS1001 or COMP1130

Fees

Tuition fees are for the academic year indicated at the top of the page.  

If you are a domestic graduate coursework or international student you will be required to pay tuition fees. Students continuing in their current program of study will have their tuition fees indexed annually from the year in which you commenced your program. Further information for domestic and international students about tuition and other fees can be found at Fees.

Student Contribution Band:
2
Unit value:
6 units

If you are an undergraduate student and have been offered a Commonwealth supported place, your fees are set by the Australian Government for each course. At ANU 1 EFTSL is 48 units (normally 8 x 6-unit courses). You can find your student contribution amount for each course at Fees.  Where there is a unit range displayed for this course, not all unit options below may be available.

Units EFTSL
6.00 0.12500
Domestic fee paying students
Year Fee
1994-2003 $1980
2004 $2088
2005 $2088
2006 $2088
2007 $2088
2008 $2190
2009 $2916
2010 $2916
2011 $2946
2012 $2946
2013 $2946
2014 $2952
International fee paying students
Year Fee
1994-2003 $3450
2004 $3450
2005 $3534
2006 $3618
2007 $3618
2008 $3618
2009 $3618
2010 $3750
2011 $3756
2012 $3756
2013 $3756
2014 $3762
Note: Please note that fee information is for current year only.

Offerings and Dates

The list of offerings for future years is indicative only

Second Semester

Class number Class start date Last day to enrol Census date Class end date Mode Of Delivery Class Summary
6897 21 Jul 2014 08 Aug 2014 31 Aug 2014 30 Oct 2014 In Person N/A

Responsible Officer: Registrar, Student Administration / Page Contact: Website Administrator / Frequently Asked Questions