COMPSCI 751 : Advanced Topics in Database Systems

Science

2021 Semester One (1213) (15 POINTS)

Course Prescription

Database principles. Relational model, relational algebra, relational calculus, SQL, SQL and programming languages, entity-relationship model, normalisation, query processing and query optimisation, ACID transactions, transaction isolation levels, database recovery, database security, databases and XML. Research frontiers in database systems. Recommended preparation: COMPSCI 220, 225.

Course Overview

Databases are at the core of most modern software applications. In this course you will learn the foundations of database systems, enabling you to build effective and efficient database applications. The course is divided into two parts: the first teaches you how to design and use a database application and the second covers transaction and looks in-depth at how database systems are built to work in the current changing environment.

Course Requirements

Prerequisite: Approval of the Academic Head or nominee Restriction: COMPSCI 351, SOFTENG 351

Capabilities Developed in this Course

Capability 1: Disciplinary Knowledge and Practice
Capability 2: Critical Thinking
Capability 3: Solution Seeking
Capability 4: Communication and Engagement
Capability 5: Independence and Integrity
Capability 6: Social and Environmental Responsibilities

Learning Outcomes

By the end of this course, students will be able to:
  1. Describe and explain the foundmental concepts and structures of how databases and database systems work. (Capability 1, 2, 3, 4 and 5)
  2. Demonstrate and apply conceptual data modelling techniques for a database design. (Capability 1, 2, 3, 4 and 5)
  3. Use and apply the relational data model and conversion of conceptual data models into relational databases. (Capability 1, 2, 3, 4 and 5)
  4. Develop the practical skills associated with Structure Query Language (SQL) to build database solutions in line with their usage. (Capability 1, 2, 3, 4 and 5)
  5. Use and apply theoretical database knowledge such as relational algebra, functional dependencies and normalisation. (Capability 1, 2 and 3)
  6. Critically evaluate quality aspects of relational database design in terms of functional dependencies and associated normal forms. (Capability 1, 2, 3, 4 and 5)
  7. Describe and explain the key implementation techniques of database management systems, such as file storage, data retrieval and indexing, etc. (Capability 1, 2, 3, 4 and 5)
  8. Describe and explain the key concurrency techniques of database management systems, such transaction processing, recovery, serializability, etc. (Capability 1, 2, 3, 4 and 5)
  9. Describe and explain the advanced data models and modern query languages. (Capability 1, 2 and 3)
  10. Describe and explain modern distributed database systems and their applications. (Capability 1, 2, 3, 4, 5 and 6)

Assessments

Assessment Type Percentage Classification
Assignments 20% Individual Coursework
Laboratories 10% Individual Coursework
Term Test 10% Individual Test
Final Exam 60% Individual Examination
Assessment Type Learning Outcome Addressed
1 2 3 4 5 6 7 8 9 10
Assignments
Laboratories
Term Test
Final Exam

Students must obtain a pass in both the Practical (labs + assignments) and Theory (test + exam) work in order to pass the course as a whole.

Tuākana

For more information and to find contact details for the Computer Science Tuākana coordinator, 
please refer to https://www.auckland.ac.nz/en/science/study-with-us/maori-and-pacific-at-the-faculty/tuakana-programme.html.

Key Topics

Focus on the fundamental concepts necessary for designing, using and implementing database systems and database applications.
  • Database Systems and Concepts 
  • Data Modeling – Entity-Relationship (ER) diagrams 
  • Relational Data Model and Database Design 
  • Structured Query Language (SQL) 
  • Relational Algebra, Functional Dependencies and Normalization 
  • Transaction processing 
  • Storage and Retrieval 
  • Data Models and Query Languages 
  • Distributed Data 

Special Requirements

Standard University health & safety requirements apply.

Workload Expectations

This course is a standard [15] point course and students are expected to spend 10 hours per week involved in each 15 point course that they are enrolled in.

For this course, you can expect [3] hours of lectures, a [1] hour tutorial, [4] hours of reading and thinking about the content and [2] hours of work on assignments and/or test preparation.

Delivery Mode

Campus Experience

This course is designed for in person delivery under normal circumstances, but is available for remote students as an emergency measure.

Attendance is [expected] at scheduled activities including [labs/tutorials] to [receive credit for] components of the course.
Lectures will be available as recordings. Other learning activities including [tutorials/labs] will [not be available] as recordings.
The course [will not] include live online events including [tutorials].
Attendance on campus is [required] for the [test]. Attendance on campus is [not required] for the [exam].
The activities for the course are scheduled as a [standard weekly timetable].

Learning Resources

The course materials will be covered by the lecture notes, lab exercises and assignment handouts. No required course book and text books associated. There are two reference text books for the purpose of additional reading only.
  • Fundamentals of Database Systems 7th, Elmasri and Navathe, Addison Wesley, 2016.
  • Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. Martin Kleppmann. 2017.
Piazza is the course forum for posting questions, answering and discussions. Students are encouraged to actively participate in the online discussions of the material taught in the course.

Student Feedback

During the course Class Representatives in each class can take feedback to the staff responsible for the course and staff-student consultative committees.

At the end of the course students will be invited to give feedback on the course and teaching through a tool called SET or Qualtrics. The lecturers and course co-ordinators will consider all feedback.

Your feedback helps to improve the course and its delivery for all students.

Digital Resources

Course materials are made available in a learning and collaboration tool called Canvas which also includes reading lists and lecture recordings (where available).

Please remember that the recording of any class on a personal device requires the permission of the instructor.

Academic Integrity

The University of Auckland will not tolerate cheating, or assisting others to cheat, and views cheating in coursework as a serious academic offence. The work that a student submits for grading must be the student's own work, reflecting their learning. Where work from other sources is used, it must be properly acknowledged and referenced. This requirement also applies to sources on the internet. A student's assessed work may be reviewed against online source material using computerised detection mechanisms.

Copyright

The content and delivery of content in this course are protected by copyright. Material belonging to others may have been used in this course and copied by and solely for the educational purposes of the University under license.

You may copy the course content for the purposes of private study or research, but you may not upload onto any third party site, make a further copy or sell, alter or further reproduce or distribute any part of the course content to another person.

Inclusive Learning

All students are asked to discuss any impairment related requirements privately, face to face and/or in written form with the course coordinator, lecturer or tutor.

Student Disability Services also provides support for students with a wide range of impairments, both visible and invisible, to succeed and excel at the University. For more information and contact details, please visit the Student Disability Services’ website http://disability.auckland.ac.nz

Special Circumstances

If your ability to complete assessed coursework is affected by illness or other personal circumstances outside of your control, contact a member of teaching staff as soon as possible before the assessment is due.

If your personal circumstances significantly affect your performance, or preparation, for an exam or eligible written test, refer to the University’s aegrotat or compassionate consideration page https://www.auckland.ac.nz/en/students/academic-information/exams-and-final-results/during-exams/aegrotat-and-compassionate-consideration.html.

This should be done as soon as possible and no later than seven days after the affected test or exam date.

Learning Continuity

In the event of an unexpected disruption we undertake to maintain the continuity and standard of teaching and learning in all your courses throughout the year. If there are unexpected disruptions the University has contingency plans to ensure that access to your course continues and your assessment is fair, and not compromised. Some adjustments may need to be made in emergencies. You will be kept fully informed by your course co-ordinator, and if disruption occurs you should refer to the University Website for information about how to proceed.

Level 1: Delivered normally as specified in delivery mode .
Level 2: You will not be required to attend in person. All teaching and assessment will have a remote option. The following activities will also have an on campus / in person option: [Lectures, labs, tutorials, office hours, etc.] .
Level 3 / 4: All teaching activities and assessments are delivered remotely .

Student Charter and Responsibilities

The Student Charter assumes and acknowledges that students are active participants in the learning process and that they have responsibilities to the institution and the international community of scholars. The University expects that students will act at all times in a way that demonstrates respect for the rights of other students and staff so that the learning environment is both safe and productive. For further information visit Student Charter https://www.auckland.ac.nz/en/students/forms-policies-and-guidelines/student-policies-and-guidelines/student-charter.html.

Disclaimer

Elements of this outline may be subject to change. The latest information about the course will be available for enrolled students in Canvas.

In this course you may be asked to submit your coursework assessments digitally. The University reserves the right to conduct scheduled tests and examinations for this course online or through the use of computers or other electronic devices. Where tests or examinations are conducted online remote invigilation arrangements may be used. The final decision on the completion mode for a test or examination, and remote invigilation arrangements where applicable, will be advised to students at least 10 days prior to the scheduled date of the assessment, or in the case of an examination when the examination timetable is published.

Published on 24/02/2021 09:53 p.m.