- Code COMP2400
- Unit Value 6 units
- Offered by Research School of Computer Science
- ANU College ANU College of Engineering and Computer Science
- Course subject Computer Science
- Areas of interest Information Technology, Software Engineering
- Academic career UGRD
- Dr Yu Lin
- Mode of delivery In Person
- Co-taught Course
Second Semester 2020
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.
Upon successful completion, students will have the knowledge and skills to:
- Describe the basic concepts of the relational model and understand its mathematical foundation;
- Use the SQL language to define, query and manipulate a relational database;
- Apply conceptual database modelling methods such as entity-relationship model to design a relational database;
- Apply database design methods on functional dependencies and normal forms to evaluate the quality of a relational database design;
- Understand query processing and optimization, transaction and security management in a relational database management system.
- Understand the state of the art of database management systems, and big data management challenges (Amazon's Dynamo, Google's BigTable, MongoDB and MapReduce).
More information may be available for enrolled students on the course website on Wattle
- Quizzes and labs (5) [LO null]
- Assignments and test (40) [LO null]
- Final Exam (55) [LO null]
In response to COVID-19: Please note that Semester 2 Class Summary information (available under the classes tab) is as up to date as possible. Changes to Class Summaries not captured by this publication will be available to enrolled students via Wattle.
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.
30 one-hour lectures and 8 two-hour laboratory sessions
Requisite and Incompatibility
Fundamentals of Database Systems, R. Elmasri and S. Navathe, 7th Edition (Global Edition), Pearson, 2017
Assumed KnowledgeCOMP1100 or COMP1710 or INFS1001 or COMP1130
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. Tuition fees are indexed annually. Further information for domestic and international students about tuition and other fees can be found at Fees.
- Student Contribution Band:
- 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.
- Domestic fee paying students
- International fee paying students
Offerings, Dates and Class Summary Links
ANU utilises MyTimetable to enable students to view the timetable for their enrolled courses, browse, then self-allocate to small teaching activities / tutorials so they can better plan their time. Find out more on the Timetable webpage.
Class summaries, if available, can be accessed by clicking on the View link for the relevant class number.
|Class number||Class start date||Last day to enrol||Census date||Class end date||Mode Of Delivery||Class Summary|
|7182||27 Jul 2020||03 Aug 2020||31 Aug 2020||30 Oct 2020||In Person||N/A|