23/11/2021, 14:33 Final Exam for: COMP9120
https://canvas.sydney.edu.au/courses/37499 1/3
This is a short release take-home exam. Open-book exams do not permit the use of third party
communication or collaboration apps or websites. Access to any such app or website is strictly
prohibited during your exam and is a serious academic integrity breach.
Date of exam: 26/11/2021
Start: 09:00 Sydney, Australia time
(https://www.timeanddate.com/worldclock/australia/sydney)
Duration: 2 hours and 55 minutes (175 minutes). This includes:
10 minutes of reading time, but you can start writing whenever you are ready– you are
strongly encouraged to use this time to carefully plan and structure your response before you
start writing.
15 minutes of upload time to allow you to upload your files as per your exam instructions. Do
NOT treat this as extra writing time. The upload time must be used solely to save and
upload your files correctly as per the exam instructions. Manage your time carefully. Check
that you have saved and named your file correctly and uploaded the correct file. If your time
runs out while you are uploading this is not considered a technical issue.
Please keep track of your time. Use the time on your computer so that you always know how
much time you have left.
If you encounter technical difficulties during the exam that prevent you from submitting your exam
on time, you should apply for special consideration.
If you have an academic adjustment, it has been added automatically. Visit the understanding
your academic adjustments (https://canvas.sydney.edu.au/courses/23380/pages/understanding-
your-academic-adjustments) page in the taking online exams help site for more information.
Format: This is a take-home exam with 10 questions. You should read the questions, and write
your answers in a word document. You should attempt all questions and follow the instructions for
each question carefully.
Question
type
Points Recommended
time spent
Question
1
Short answer 4 10 minutes
Question
2
Short answer 4 10 minutes
Question
3
Storage and
Indexing
4 10 minutes
Question
4
Schema
Refinement
6 15 minutes
https://www.timeanddate.com/worldclock/australia/sydney
https://canvas.sydney.edu.au/courses/23380/pages/understanding-your-academic-adjustments
23/11/2021, 14:33 Final Exam for: COMP9120
https://canvas.sydney.edu.au/courses/37499 2/3
Question
type
Points Recommended
time spent
Question
5
Normalization 4 10 minutes
Question
6
Transaction 4 10 minutes
Question
7
Integrity
Constraints
4 10 minutes
Question
8
Writing
Relational
Algebra
5 20 minutes
Question
9
Writing SQL
queries
5 20 minutes
Question
10
Drawing ER
diagram
10 35 minutes
Specific instructions for test upload: How to upload images to an assignment
(https://canvas.sydney.edu.au/courses/23380/pages/uploading-handwritten-images-to-canvas-
assignments) Please upload the pdf version of your solution document. Only if you are having
difficulty converting your word document into pdf, then upload the word file.
Materials required: None
Materials provided and further instructions: None
Review the Student Charter (https://www.sydney.edu.au/policies/showdoc.aspx?
recnum=PDOC2011/215&RendNum=0) , (https://www.sydney.edu.au/policies/showdoc.aspx?
recnum=PDOC2011/215&RendNum=0) your academic integrity responsibilities
(https://www.sydney.edu.au/students/academic-integrity.html) and the integrity contract
(https://canvas.sydney.edu.au/courses/23380/pages/academic-honesty-statement)
START YOUR EXAM
(https://canvas.sydney.edu.au/courses/37499/assignments)
This exam must be taken on a computer or laptop with satisfactory internet connectivity. It
must NOT be taken on a mobile device.
You can book a space in the library (https://library.sydney.edu.au/libraries/room-
booking.html) Headphones are required if you sit an exam in a library space.
It is recommended that you restart your computer, update your internet browser, and clear your
browser’s cache before beginning this exam. Google Chrome and Mozilla Firefox are the
preferred browsers for accessing Canvas.
https://canvas.sydney.edu.au/courses/23380/pages/uploading-handwritten-images-to-canvas-assignments
https://www.sydney.edu.au/policies/showdoc.aspx?recnum=PDOC2011/215&RendNum=0
https://www.sydney.edu.au/policies/showdoc.aspx?recnum=PDOC2011/215&RendNum=0
https://www.sydney.edu.au/students/academic-integrity.html
https://canvas.sydney.edu.au/courses/23380/pages/academic-honesty-statement
https://canvas.sydney.edu.au/courses/37499/assignments
https://library.sydney.edu.au/libraries/room-booking.html
23/11/2021, 14:33 Final Exam for: COMP9120
https://canvas.sydney.edu.au/courses/37499 3/3
Copyright © The University of Sydney. Unless otherwise indicated, 3rd party material has been reproduced and communicated to you by or on behalf of
the University of Sydney in accordance with section 113P of the Copyright Act 1968 (Act). The material in this communication may be subject to
copyright under the Act. Any further reproduction or communication of this material by you may be the subject of copyright protection under the Act. Do
not remove this notice.
Live streamed classes in this unit may be recorded to enable students to review the content. If you have concerns about this, please visit our student
guide (https://canvas.sydney.edu.au/courses/4901/pages/zoom) and contact the unit coordinator.
Clearing your cache for Google Chrome
(https://support.google.com/accounts/answer/32050?co=GENIE.Platform%3DDesktop&hl=en)
Clearing your cache for Mozilla Firefox (https://support.mozilla.org/en-US/kb/how-clear-
firefox-cache)
If you are uncertain about a question during the exam, answer to the best of your ability. Do
not contact the unit coordinator or other teaching staff during the exam. After the exam, email
your unit coordinator with information including the question and question number.
If you encounter technical difficulties during the exam that you cannot fix,
email canvas. .au (mailto:canvas. .au) with your unit of
study code, contact number and SID. You must contact us before your quiz or assignment
has closed for submission. We cannot provide assistance after submission closes.
If you encounter technical difficulties during the exam that affect your ability to complete the
exam you will need to describe your problems on a Student Declaration
(https://www.sydney.edu.au/content/dam/students/documents/admin/student-declaration.docx)
and apply for Special Consideration (https://special-
considerations.sydney.edu.au/Runtime/Runtime/Form/Sas.Forms.Student.Dashboard)
https://canvas.sydney.edu.au/courses/4901/pages/zoom
https://support.google.com/accounts/answer/32050?co=GENIE.Platform%3DDesktop&hl=en
https://support.mozilla.org/en-US/kb/how-clear-firefox-cache
mailto:canvas. .au
https://www.sydney.edu.au/content/dam/students/documents/admin/student-declaration.docx
https://special-considerations.sydney.edu.au/Runtime/Runtime/Form/Sas.Forms.Student.Dashboard