- Class Number 7391
- Term Code 3260
- Class Info
- Unit Value 6 units
- Mode of Delivery In Person
- Dr Yu Lin
- AsPr Qing Wang
- Dr Yu Lin
- Class Dates
- Class Start Date 25/07/2022
- Class End Date 28/10/2022
- Census Date 31/08/2022
- Last Date to Enrol 01/08/2022
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).
This course will provide students with the opportunities:
1. To develop knowledge of a range of theoretical database concepts and practical skills;
2. To learn about some latest industry and research development in the field of databases.
A laptop or desktop is needed for accessing the course materials on Wattle and for completing the assignments.
The recommended (not required) textbook for this course is
Fundamentals of Database Systems, 7th Edition, R. Elmasri and S. Navathe, Global Edition, 2017
This book has also been published under different titles and with different front covers (see below, 4th, 5thor 6th editions, etc.). These earlier versions are also fine for this course. The textbook is available from the Co-op bookshop. Some copies of this book (including both 7th and earlier editions) are available in the reserve section of the Hancock Library.
Staff FeedbackStudents will be given feedback in the following forms in this course:
- Written comments
- Verbal comments
- Feedback to the whole class, to groups, to individuals, focus groups
Student FeedbackANU is committed to the demonstration of educational excellence and regularly seeks feedback from students. Students are encouraged to offer feedback directly to their Course Convener or through their College and Course representatives (if applicable). The feedback given in these surveys is anonymous and provides the Colleges, University Education Committee and Academic Board with opportunities to recognise excellent teaching, and opportunities for improvement. The Surveys and Evaluation website provides more information on student surveys at ANU and reports on the feedback provided on ANU courses.
|Week/Session||Summary of Activities||Assessment|
|1||Lectures: Introduction to Database Systems No lab|
|2||Lectures: Relational Data Model and SQL (1) Lab: Lab Environment||Quiz|
|3||Lectures: Relational Data Model and SQL (2) Lab: Basic SQL||Quiz|
|4||Lectures: Entity-Relationship Model Lab: Advanced SQL||Quiz|
|5||Lectures: Functional Dependencies Lab: Entity-Relationship Model||Quiz|
|6||Lectures: Normalisation No lab||Quiz, Assignment on SQL|
|7||Lectures: Relational Algebra Lab: Functional Dependencies||Quiz|
|8||Lectures: Query Processing and Optimisation Lab: Normalisation||Quiz|
|9||Lectures: Database Security Lab: Relational Algebra and Query Processing||Quiz|
|10||Lectures: Database Transactions Lab (optional): Database Programming||Quiz, Assignment on Database Theory|
|11||Lectures: NoSQL Databases No lab||Quiz|
|12||Lectures: Revision No lab||Test on NoSQL|
Refer to the information on the course Wattle site.
|Assessment task||Value||Due Date||Return of assessment||Learning Outcomes|
|1. Quizzes and Labs||5 %||*||*||1,2,3,4,5,6|
|2. Assignment on SQL||20 %||30/08/2022||13/09/2022||1,2|
|3. Assignment on Database Theory||15 %||11/10/2022||25/10/2022||3,4,5|
|4. Test on NoSQL||5 %||27/10/2022||28/10/2022||6|
|5. Final Exam||55 %||*||*||1,2,3,4,5|
* If the Due Date and Return of Assessment date are blank, see the Assessment Tab for specific Assessment Task details
PoliciesANU has educational policies, procedures and guidelines, which are designed to ensure that staff and students are aware of the University’s academic standards, and implement them. Students are expected to have read the Academic Misconduct Rule before the commencement of their course. Other key policies and guidelines include:
Assessment RequirementsThe ANU is using 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. For additional information regarding Turnitin please visit the ANU Online website Students may choose not to submit assessment items through Turnitin. In this instance you will be required to submit, alongside the assessment item itself, hard copies of all references included in the assessment item.
Moderation of AssessmentMarks that are allocated during Semester are to be considered provisional until formalised by the College examiners meeting at the end of each Semester. If appropriate, some moderation of marks might be applied prior to final results being released.
Assessment Task 1
Learning Outcomes: 1,2,3,4,5,6
1. Quizzes and Labs
There will be 10 weekly online quizzes on the course Wattle site from Week 2 to Week 11. Only one attempt is allowed for each quiz. Each quiz values 0.5% and the best 6 of 10 quizzes (at most 3% in total) will be counted toward your final grade. There will be 8 two-hour lab sessions starting from Week 2. The first lab session (i.e., Lab 1 in Week 2) will be on the basic computer skills needed to do the more substantial exercises in the course. The last lab session (i.e., Lab 8 in Week 10) is to provide students with an additional opportunity to experience database programming, which will not be assessed in the assignments and exams of this course. The labs from Week 2 to Week 10 (except Week 6) in this course serve the purpose of deepening the understanding of the lecture material and preparing students for the assignments and exams. Students are encouraged to participate and engage with the labs. The engagement of each lab values 0.5% and at most four lab engagements (2% in total) will be counted toward your final grade.
Assessment Task 2
Learning Outcomes: 1,2
2. Assignment on SQL
The assignment on SQL covers SQL programming. This assessment should be done individually and no group work is allowed. The detailed specifications will be made available on the course Wattle site, two weeks before the due dates.
Assessment Task 3
Learning Outcomes: 3,4,5
3. Assignment on Database Theory
The assignment on database theory covers the entity-relationship model, functional dependencies, normalisation relational algebra, query processing and optimisation. This assignment should be done individually and no group work is allowed. The detailed specifications will be made available on the course Wattle site, two weeks before the due dates.
Assessment Task 4
Learning Outcomes: 6
4. Test on NoSQL
Test on NoSQL covers NoSQL databases and it consists of multiple-choice questions on the course Wattle site. More details will be given on the course Wattle site in Week 12.
Assessment Task 5
Learning Outcomes: 1,2,3,4,5
5. Final Exam
The final exam covers all the topics except NoSQL databases. More information will be made available on the course Wattle site in Week 12. To pass the course, it is required to obtain at least 40% in the final exam.
Academic IntegrityAcademic integrity is a core part of our culture as a community of scholars. At its heart, academic integrity is about behaving ethically. This means that all members of the community commit to honest and responsible scholarly practice and to upholding these values with respect and fairness. The Australian National University commits to embedding the values of academic integrity in our teaching and learning. We ensure that all members of our community understand how to engage in academic work in ways that are consistent with, and actively support academic integrity. The ANU expects staff and students to uphold high standards of academic integrity and act ethically and honestly, to ensure the quality and value of the qualification that you will graduate with. The University has policies and procedures in place to promote academic integrity and manage academic misconduct. Visit the following Academic honesty & plagiarism website for more information about academic integrity and what the ANU considers academic misconduct. The ANU offers a number of services to assist students with their assignments, examinations, and other learning activities. The Academic Skills and Learning Centre offers a number of workshops and seminars that you may find useful for your studies.
Refer to the course Wattle site for online submission information of assignments.
Hard copy submission should be approved by the Associate Dean (Education).
No submission of assessment tasks without an extension after the due date will be permitted. If an assessment task is not submitted by the due date, a mark of 0 will be awarded.
Referencing RequirementsAccepted academic practice for referencing sources that you use in presentations can be found via the links on the Wattle site, under the file named “ANU and College Policies, Program Information, Student Support Services and Assessment”. Alternatively, you can seek help through the Students Learning Development website.
Extensions and PenaltiesExtensions and late submission of assessment pieces are covered by the Student Assessment (Coursework) Policy and Procedure The Course Convener may grant extensions for assessment pieces that are not examinations or take-home examinations. If you need an extension, you must request an extension in writing on or before the due date. If you have documented and appropriate medical evidence that demonstrates you were not able to request an extension on or before the due date, you may be able to request it after the due date.
Distribution of grades policyAcademic Quality Assurance Committee monitors the performance of students, including attrition, further study and employment rates and grade distribution, and College reports on quality assurance processes for assessment activities, including alignment with national and international disciplinary and interdisciplinary standards, as well as qualification type learning outcomes. Since first semester 1994, ANU uses a grading scale for all courses. This grading scale is used by all academic areas of the University.
Support for studentsThe University offers students support through several different services. You may contact the services listed below directly or seek advice from your Course Convener, Student Administrators, or your College and Course representatives (if applicable).
- ANU Health, safety & wellbeing for medical services, counselling, mental health and spiritual support
- ANU Diversity and inclusion for students with a disability or ongoing or chronic illness
- ANU Dean of Students for confidential, impartial advice and help to resolve problems between students and the academic or administrative areas of the University
- ANU Academic Skills and Learning Centre supports you make your own decisions about how you learn and manage your workload.
- ANU Counselling Centre promotes, supports and enhances mental health and wellbeing within the University student community.
- ANUSA supports and represents undergraduate and ANU College students
- PARSA supports and represents postgraduate and research students
Bioinformatics Algorithms and Data Analysis
Dr Yu Lin
AsPr Qing Wang