This course is an introduction to database concepts and the general skills for designing and using databases, with a focus on relational database concepts and techniques. Current industry developments of database systems such as NoSQL databases will be introduced at the end of the course.
Learning Outcomes
Upon successful completion, students will have the knowledge and skills to:
- Interpret and explain the basic concepts of the relational model and understand its mathematical foundation
- Apply 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
- Research, justify and apply database design methods on functional dependencies and normal forms to evaluate the quality of a relational database design
- Interpret and discuss query processing and optimisation, transaction and security management in a relational database management system
- Reflect upon state of the art of database management systems and big data management challenges
Other Information
Students not enrolled in programs GCDE, DADAN, MADAN or CADAN, who wish to enrol must apply for a permission code by contacting CECC Student Services (studentadmin.cecc@anu.edu.au). Approval will only be given for exceptional cases of need, not cases of convenience, and only after approval from the student's program convenor that the need is justified.
Indicative Assessment
- Written assignments (35) [LO 1,3,5]
- Online quizzes (5) [LO 1,2,3,4,5]
- SQL assignment (10) [LO 2]
- Final examination (50) [LO 1,2,3,4,5,6]
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
Approx 130 hours
Inherent Requirements
Not applicable
Requisite and Incompatibility
Prescribed Texts
None
Fees
Tuition fees are for the academic year indicated at the top of the page.
Commonwealth Support (CSP) Students
If you 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). More information about your student contribution amount for each course at Fees.
- Student Contribution Band:
- 2
- Unit value:
- 6 units
If you are a domestic graduate coursework student with a Domestic Tuition Fee (DTF) place or international student you will be required to pay course tuition fees (see below). Course tuition fees are indexed annually. Further information for domestic and international students about tuition and other fees can be found 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 |
Course fees
- Domestic fee paying students
| Year | Fee |
|---|---|
| 2024 | $4980 |
- International fee paying students
| Year | Fee |
|---|---|
| 2024 | $6360 |
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.