1/26
Revision – Final Exam Information
2/26
NoSQL Test
The NoSQL test was available from 12:00pm, 23 October (Saturday) to
11:59pm, 28 October (Thursday).
The NoSQL results will be released on 29 October (Friday).
Special Drop-in Session: 2-3 pm (Tuesday) 2 November.
3/26
Final Exam
Time:
COMP2400: 5:40 pm, 8 November (Monday) 2021
COMP6240: 5:30 pm, 8 November (Monday) 2021
Writing period: 150 minutes
Venue: Online Wattle Exam
Refer to the following website for the final exam time
https://exams.anu.edu.au/timetable/
Application for deferred-examinations:
https://www.anu.edu.au/students/program-administration/
assessments-exams/deferred-examinations
https://exams.anu.edu.au/timetable/
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
3/26
Final Exam
Time:
COMP2400: 5:40 pm, 8 November (Monday) 2021
COMP6240: 5:30 pm, 8 November (Monday) 2021
Writing period: 150 minutes
Venue: Online Wattle Exam
Refer to the following website for the final exam time
https://exams.anu.edu.au/timetable/
Application for deferred-examinations:
https://www.anu.edu.au/students/program-administration/
assessments-exams/deferred-examinations
https://exams.anu.edu.au/timetable/
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
3/26
Final Exam
Time:
COMP2400: 5:40 pm, 8 November (Monday) 2021
COMP6240: 5:30 pm, 8 November (Monday) 2021
Writing period: 150 minutes
Venue: Online Wattle Exam
Refer to the following website for the final exam time
https://exams.anu.edu.au/timetable/
Application for deferred-examinations:
https://www.anu.edu.au/students/program-administration/
assessments-exams/deferred-examinations
https://exams.anu.edu.au/timetable/
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
3/26
Final Exam
Time:
COMP2400: 5:40 pm, 8 November (Monday) 2021
COMP6240: 5:30 pm, 8 November (Monday) 2021
Writing period: 150 minutes
Venue: Online Wattle Exam
Refer to the following website for the final exam time
https://exams.anu.edu.au/timetable/
Application for deferred-examinations:
https://www.anu.edu.au/students/program-administration/
assessments-exams/deferred-examinations
https://exams.anu.edu.au/timetable/
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
3/26
Final Exam
Time:
COMP2400: 5:40 pm, 8 November (Monday) 2021
COMP6240: 5:30 pm, 8 November (Monday) 2021
Writing period: 150 minutes
Venue: Online Wattle Exam
Refer to the following website for the final exam time
https://exams.anu.edu.au/timetable/
Application for deferred-examinations:
https://www.anu.edu.au/students/program-administration/
assessments-exams/deferred-examinations
https://exams.anu.edu.au/timetable/
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
3/26
Final Exam
Time:
COMP2400: 5:40 pm, 8 November (Monday) 2021
COMP6240: 5:30 pm, 8 November (Monday) 2021
Writing period: 150 minutes
Venue: Online Wattle Exam
Refer to the following website for the final exam time
https://exams.anu.edu.au/timetable/
Application for deferred-examinations:
https://www.anu.edu.au/students/program-administration/
assessments-exams/deferred-examinations
https://exams.anu.edu.au/timetable/
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
https://www.anu.edu.au/students/program-administration/assessments-exams/deferred-examinations
4/26
Importance of Final Exam
5% Quizzes and Labs Best 6 out of 10 quizzes (0.5% ×
6 = 3%) and engaging 4 out of 8
labs (0.5% × 4 = 2%, at your own
choice).
35% Assignments In total (20% + 15% = 35%).
5% NoSQL test An online test about NoSQL
databases on Wattle.
55% Final exam The final exam will take place on 8
November 2021 .
5/26
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course.
To pass the course you must achieve:
at least 40% in the final examination (i.e., 22/55),
at least 50% as a combined total of quizzes, labs, assignments,
NoSQL test and final exam
The final marks will be moderated in the examiners’s meeting and may be
scaled as a result of this moderation.
5/26
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course.
To pass the course you must achieve:
at least 40% in the final examination (i.e., 22/55),
at least 50% as a combined total of quizzes, labs, assignments,
NoSQL test and final exam
The final marks will be moderated in the examiners’s meeting and may be
scaled as a result of this moderation.
5/26
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course.
To pass the course you must achieve:
at least 40% in the final examination (i.e., 22/55),
at least 50% as a combined total of quizzes, labs, assignments,
NoSQL test and final exam
The final marks will be moderated in the examiners’s meeting and may be
scaled as a result of this moderation.
5/26
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course.
To pass the course you must achieve:
at least 40% in the final examination (i.e., 22/55),
at least 50% as a combined total of quizzes, labs, assignments,
NoSQL test and final exam
The final marks will be moderated in the examiners’s meeting and may be
scaled as a result of this moderation.
5/26
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course.
To pass the course you must achieve:
at least 40% in the final examination (i.e., 22/55),
at least 50% as a combined total of quizzes, labs, assignments,
NoSQL test and final exam
The final marks will be moderated in the examiners’s meeting and may be
scaled as a result of this moderation.
5/26
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course.
To pass the course you must achieve:
at least 40% in the final examination (i.e., 22/55),
at least 50% as a combined total of quizzes, labs, assignments,
NoSQL test and final exam
The final marks will be moderated in the examiners’s meeting and may be
scaled as a result of this moderation.
6/26
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle).
Note that this process is encouraged, but not required.
You will not be asked to pass your recording on to ANU.
You should keep your recording safely for one month.
If the ANU should raise any concerns about the integrity of the work you did
during the exam, you will have the option to submit your screen recording as
evidence to support your case.
If you should experience any unexpected issues on Wattle, you will have the
option to submit your screen recording as evidence to support your case.
6/26
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle).
Note that this process is encouraged, but not required.
You will not be asked to pass your recording on to ANU.
You should keep your recording safely for one month.
If the ANU should raise any concerns about the integrity of the work you did
during the exam, you will have the option to submit your screen recording as
evidence to support your case.
If you should experience any unexpected issues on Wattle, you will have the
option to submit your screen recording as evidence to support your case.
6/26
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle).
Note that this process is encouraged, but not required.
You will not be asked to pass your recording on to ANU.
You should keep your recording safely for one month.
If the ANU should raise any concerns about the integrity of the work you did
during the exam, you will have the option to submit your screen recording as
evidence to support your case.
If you should experience any unexpected issues on Wattle, you will have the
option to submit your screen recording as evidence to support your case.
6/26
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle).
Note that this process is encouraged, but not required.
You will not be asked to pass your recording on to ANU.
You should keep your recording safely for one month.
If the ANU should raise any concerns about the integrity of the work you did
during the exam, you will have the option to submit your screen recording as
evidence to support your case.
If you should experience any unexpected issues on Wattle, you will have the
option to submit your screen recording as evidence to support your case.
6/26
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle).
Note that this process is encouraged, but not required.
You will not be asked to pass your recording on to ANU.
You should keep your recording safely for one month.
If the ANU should raise any concerns about the integrity of the work you did
during the exam, you will have the option to submit your screen recording as
evidence to support your case.
If you should experience any unexpected issues on Wattle, you will have the
option to submit your screen recording as evidence to support your case.
6/26
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle).
Note that this process is encouraged, but not required.
You will not be asked to pass your recording on to ANU.
You should keep your recording safely for one month.
If the ANU should raise any concerns about the integrity of the work you did
during the exam, you will have the option to submit your screen recording as
evidence to support your case.
If you should experience any unexpected issues on Wattle, you will have the
option to submit your screen recording as evidence to support your case.
7/26
What you need to know before the exam:
The final exam will be held via this Wattle course site. You can only log in
Wattle from one machine during your final exam period. Otherwise, your
final exam may be terminated by the system.
Our IT Support recommends that you use Firefox or Google Chrome for
this final exam, and do not use Safari.
You only have one attempt for this final exam.
This is an open book exam. However, you must complete this exam
independently and with academic integrity.
(Optional) Find screen recording software that you trust works well on your
computer (refer to Wattle). Test it, and make sure you can successfully
record the whole of your screen for self invigilation.
7/26
What you need to know before the exam:
The final exam will be held via this Wattle course site. You can only log in
Wattle from one machine during your final exam period. Otherwise, your
final exam may be terminated by the system.
Our IT Support recommends that you use Firefox or Google Chrome for
this final exam, and do not use Safari.
You only have one attempt for this final exam.
This is an open book exam. However, you must complete this exam
independently and with academic integrity.
(Optional) Find screen recording software that you trust works well on your
computer (refer to Wattle). Test it, and make sure you can successfully
record the whole of your screen for self invigilation.
7/26
What you need to know before the exam:
The final exam will be held via this Wattle course site. You can only log in
Wattle from one machine during your final exam period. Otherwise, your
final exam may be terminated by the system.
Our IT Support recommends that you use Firefox or Google Chrome for
this final exam, and do not use Safari.
You only have one attempt for this final exam.
This is an open book exam. However, you must complete this exam
independently and with academic integrity.
(Optional) Find screen recording software that you trust works well on your
computer (refer to Wattle). Test it, and make sure you can successfully
record the whole of your screen for self invigilation.
7/26
What you need to know before the exam:
The final exam will be held via this Wattle course site. You can only log in
Wattle from one machine during your final exam period. Otherwise, your
final exam may be terminated by the system.
Our IT Support recommends that you use Firefox or Google Chrome for
this final exam, and do not use Safari.
You only have one attempt for this final exam.
This is an open book exam. However, you must complete this exam
independently and with academic integrity.
(Optional) Find screen recording software that you trust works well on your
computer (refer to Wattle). Test it, and make sure you can successfully
record the whole of your screen for self invigilation.
7/26
What you need to know before the exam:
The final exam will be held via this Wattle course site. You can only log in
Wattle from one machine during your final exam period. Otherwise, your
final exam may be terminated by the system.
Our IT Support recommends that you use Firefox or Google Chrome for
this final exam, and do not use Safari.
You only have one attempt for this final exam.
This is an open book exam. However, you must complete this exam
independently and with academic integrity.
(Optional) Find screen recording software that you trust works well on your
computer (refer to Wattle). Test it, and make sure you can successfully
record the whole of your screen for self invigilation.
8/26
What you need to do during the exam:
Make yourself comfortable and power down all communication channels,
except the exam zoom session.
(Optional) Start your full screen recording.
COMP2400 students must enter their answers to Wattle between 5:40 pm
and 8:10 pm (150 mins) and submit their answers before 8:15 pm. The
additional 5-minute window (8:10 pm – 8:15 pm) must only be used for your
submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your
answers may not be saved and submitted.
COMP6240 students must enter their answers to Wattle between 5:30 pm
and 8:00 pm (150 mins) and submit their answers before 8:05 pm. The
additional 5-minute window (8:00 pm – 8:05 pm) must only be used for your
submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your
answers may not be saved and submitted.
(Optional) At the end of the exam, stop your screen recording, save it, check
it, and keep it in a safe place for one month. Do not send it to ANU.
8/26
What you need to do during the exam:
Make yourself comfortable and power down all communication channels,
except the exam zoom session.
(Optional) Start your full screen recording.
COMP2400 students must enter their answers to Wattle between 5:40 pm
and 8:10 pm (150 mins) and submit their answers before 8:15 pm. The
additional 5-minute window (8:10 pm – 8:15 pm) must only be used for your
submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your
answers may not be saved and submitted.
COMP6240 students must enter their answers to Wattle between 5:30 pm
and 8:00 pm (150 mins) and submit their answers before 8:05 pm. The
additional 5-minute window (8:00 pm – 8:05 pm) must only be used for your
submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your
answers may not be saved and submitted.
(Optional) At the end of the exam, stop your screen recording, save it, check
it, and keep it in a safe place for one month. Do not send it to ANU.
8/26
What you need to do during the exam:
Make yourself comfortable and power down all communication channels,
except the exam zoom session.
(Optional) Start your full screen recording.
COMP2400 students must enter their answers to Wattle between 5:40 pm
and 8:10 pm (150 mins) and submit their answers before 8:15 pm. The
additional 5-minute window (8:10 pm – 8:15 pm) must only be used for your
submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your
answers may not be saved and submitted.
COMP6240 students must enter their answers to Wattle between 5:30 pm
and 8:00 pm (150 mins) and submit their answers before 8:05 pm. The
additional 5-minute window (8:00 pm – 8:05 pm) must only be used for your
submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your
answers may not be saved and submitted.
(Optional) At the end of the exam, stop your screen recording, save it, check
it, and keep it in a safe place for one month. Do not send it to ANU.
8/26
What you need to do during the exam:
Make yourself comfortable and power down all communication channels,
except the exam zoom session.
(Optional) Start your full screen recording.
COMP2400 students must enter their answers to Wattle between 5:40 pm
and 8:10 pm (150 mins) and submit their answers before 8:15 pm. The
additional 5-minute window (8:10 pm – 8:15 pm) must only be used for your
submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your
answers may not be saved and submitted.
COMP6240 students must enter their answers to Wattle between 5:30 pm
and 8:00 pm (150 mins) and submit their answers before 8:05 pm. The
additional 5-minute window (8:00 pm – 8:05 pm) must only be used for your
submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your
answers may not be saved and submitted.
(Optional) At the end of the exam, stop your screen recording, save it, check
it, and keep it in a safe place for one month. Do not send it to ANU.
8/26
What you need to do during the exam:
Make yourself comfortable and power down all communication channels,
except the exam zoom session.
(Optional) Start your full screen recording.
COMP2400 students must enter their answers to Wattle between 5:40 pm
and 8:10 pm (150 mins) and submit their answers before 8:15 pm. The
additional 5-minute window (8:10 pm – 8:15 pm) must only be used for your
submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your
answers may not be saved and submitted.
COMP6240 students must enter their answers to Wattle between 5:30 pm
and 8:00 pm (150 mins) and submit their answers before 8:05 pm. The
additional 5-minute window (8:00 pm – 8:05 pm) must only be used for your
submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your
answers may not be saved and submitted.
(Optional) At the end of the exam, stop your screen recording, save it, check
it, and keep it in a safe place for one month. Do not send it to ANU.
9/26
Pre-Final Exam Support
Make effective use of the Wattle discussion forum!
Drop-in Sessions (Next Week)
1 4-5 pm, Monday, Nov 1
2 7-8 pm, Wednesday, Nov 3
3 4-5 pm, Thursday, Nov 4
4 4-5 pm, Friday, Nov 5
Emails
Yu Lin: yu. .au or Qing Wang: qing. .au
10/26
Final Exam
How to prepare for the final exam for COMP2400/6240?
11/26
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions)
DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
You may also use the textbook as a reference, or search on Google …
11/26
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions)
DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
You may also use the textbook as a reference, or search on Google …
11/26
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions)
DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
You may also use the textbook as a reference, or search on Google …
11/26
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions)
DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
You may also use the textbook as a reference, or search on Google …
11/26
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions)
DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
You may also use the textbook as a reference, or search on Google …
11/26
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions)
DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
You may also use the textbook as a reference, or search on Google …
11/26
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions)
DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
You may also use the textbook as a reference, or search on Google …
11/26
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions)
DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
You may also use the textbook as a reference, or search on Google …
11/26
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions)
DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
You may also use the textbook as a reference, or search on Google …
12/26
What have you learned?
Weeks Lectures/Workshops
1 Introduction to database systems
2 Relational data model
3 SQL
4 Entity-relationship model
5 Functional dependencies
6 Normalisation
7 Relational algebra
8 Query processing and optimisation
9 Database security
10 Database transactions
11 NoSQL Databases
13/26
What will be covered in the final exam?
Weeks Lectures/Workshops
1 Introduction to database systems
2 Relational data model
3 SQL (Writing SQL queries will not be assessed)
4 Entity-relationship model
5 Functional dependencies
6 Normalisation
7 Relational algebra
8 Query processing and optimisation
9 Database security
10 Database transactions
11 NoSQL Databases
Armstrongs Inference Rules in Week 5 workshop slides (slides 16-25) will not be covered.
Execution plan in Week 8 workshop slides (slides 8-27) will not be covered.
14/26
What will be covered in the final exam?
Labs Topics
1 Lab Environment
2 Basic SQL
3 Advanced SQL
4 Entity-Relationship Model
5 Functional Dependencies
6 Normalisation
7 Relational Algebra, and Query Processing and Optimisation
8 Database Programming
15/26
Final Exam – Assignments and Past Exam Papers
The assignment on SQL will not be covered.
The assignment on database theory is covered.
The NoSQL test will not be covered.
The final exam paper in 2012 (the specification and solution are available in
Wattle). Note the difference.
15/26
Final Exam – Assignments and Past Exam Papers
The assignment on SQL will not be covered.
The assignment on database theory is covered.
The NoSQL test will not be covered.
The final exam paper in 2012 (the specification and solution are available in
Wattle). Note the difference.
15/26
Final Exam – Assignments and Past Exam Papers
The assignment on SQL will not be covered.
The assignment on database theory is covered.
The NoSQL test will not be covered.
The final exam paper in 2012 (the specification and solution are available in
Wattle). Note the difference.
15/26
Final Exam – Assignments and Past Exam Papers
The assignment on SQL will not be covered.
The assignment on database theory is covered.
The NoSQL test will not be covered.
The final exam paper in 2012 (the specification and solution are available in
Wattle). Note the difference.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D)
will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E)
will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D)
will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
16/26
Final Exam Questions
Question type:
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
+0.4 for each correct one and -0.4 for each incorrect one
Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
(A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
(A)(B)(D) and (D) will receive 0 (out of 2) marks.
17/26
Final Exam Questions
Question type:
(2) Problem-Solving Questions (remaining 9 questions)
Include necessary justifications if instructed.
Type your answer in the text window (or upload at most one file if you
think it is necessary)
17/26
Final Exam Questions
Question type:
(2) Problem-Solving Questions (remaining 9 questions)
Include necessary justifications if instructed.
Type your answer in the text window (or upload at most one file if you
think it is necessary)
18/26
Final Exam Questions
Question type:
(2) Problem-Solving Questions (remaining 9 questions)
19/26
Final Exam on Wattle
The final exam will be available on Nov 8 at the bottom of the course Wattle
site.
You can find two mock entries (available from 12pm Oct 30 to 12 pm Nov 7)
at the bottom of the course Wattle site.
COMP2400 Final Exam (Mock Test)
COMP6240 Final Exam (Mock Test)
In the final exam you must choose either COMP2400 or COMP6240
depending on your enrollment information.
19/26
Final Exam on Wattle
The final exam will be available on Nov 8 at the bottom of the course Wattle
site.
You can find two mock entries (available from 12pm Oct 30 to 12 pm Nov 7)
at the bottom of the course Wattle site.
COMP2400 Final Exam (Mock Test)
COMP6240 Final Exam (Mock Test)
In the final exam you must choose either COMP2400 or COMP6240
depending on your enrollment information.
20/26
Assignment 2 – Q1
The requirements that cannot be captured in an EER-diagram.
The work type of administrators can be either remote, onsite or hybrid.
Once a ride is completed, the customers credit card will be automatically
charged by ACTScooter.
21/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether Σ |= AB → CDE?
Check whether the closure of AB under Σ contains CDE?
How to compute the closure of AB under Σ?
(AB)+ = (ABC)+ (using AB → C) = ABCDE (using C → DE)
The closure of AB under Σ contains CDE and thus Σ |= AB→ CDE.
21/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether Σ |= AB → CDE?
Check whether the closure of AB under Σ contains CDE?
How to compute the closure of AB under Σ?
(AB)+ = (ABC)+ (using AB → C) = ABCDE (using C → DE)
The closure of AB under Σ contains CDE and thus Σ |= AB→ CDE.
21/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether Σ |= AB → CDE?
Check whether the closure of AB under Σ contains CDE?
How to compute the closure of AB under Σ?
(AB)+ = (ABC)+ (using AB → C) = ABCDE (using C → DE)
The closure of AB under Σ contains CDE and thus Σ |= AB→ CDE.
21/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether Σ |= AB → CDE?
Check whether the closure of AB under Σ contains CDE?
How to compute the closure of AB under Σ?
(AB)+ = (ABC)+ (using AB → C) = ABCDE (using C → DE)
The closure of AB under Σ contains CDE and thus Σ |= AB→ CDE.
21/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether Σ |= AB → CDE?
Check whether the closure of AB under Σ contains CDE?
How to compute the closure of AB under Σ?
(AB)+ = (ABC)+ (using AB → C) = ABCDE (using C → DE)
The closure of AB under Σ contains CDE and thus Σ |= AB→ CDE.
21/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether Σ |= AB → CDE?
Check whether the closure of AB under Σ contains CDE?
How to compute the closure of AB under Σ?
(AB)+ = (ABC)+ (using AB → C) = ABCDE (using C → DE)
The closure of AB under Σ contains CDE and thus Σ |= AB→ CDE.
22/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether ADE is a candidate key (minimal super key)?
Check whether ADE is a superkey (The closure of ADE is ABCDE?)
Check whether ADE is a minimal superkey (None of AD, AE, DE is a
superkey)
ADE is a minimal super key and thus a candididate key.
22/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether ADE is a candidate key (minimal super key)?
Check whether ADE is a superkey
(The closure of ADE is ABCDE?)
Check whether ADE is a minimal superkey (None of AD, AE, DE is a
superkey)
ADE is a minimal super key and thus a candididate key.
22/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether ADE is a candidate key (minimal super key)?
Check whether ADE is a superkey (The closure of ADE is ABCDE?)
Check whether ADE is a minimal superkey (None of AD, AE, DE is a
superkey)
ADE is a minimal super key and thus a candididate key.
22/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether ADE is a candidate key (minimal super key)?
Check whether ADE is a superkey (The closure of ADE is ABCDE?)
Check whether ADE is a minimal superkey
(None of AD, AE, DE is a
superkey)
ADE is a minimal super key and thus a candididate key.
22/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether ADE is a candidate key (minimal super key)?
Check whether ADE is a superkey (The closure of ADE is ABCDE?)
Check whether ADE is a minimal superkey (None of AD, AE, DE is a
superkey)
ADE is a minimal super key and thus a candididate key.
22/26
Assignment 2 – Q2
Consider the relation schema R = {A,B,C,D,E} and the following
set Σ of FDs:
AB → C
BC → A
C → DE
DE → B
How to check whether ADE is a candidate key (minimal super key)?
Check whether ADE is a superkey (The closure of ADE is ABCDE?)
Check whether ADE is a minimal superkey (None of AD, AE, DE is a
superkey)
ADE is a minimal super key and thus a candididate key.
23/26
Assignment 2 – Q2
Minimal Cover Main steps:
Step (1) Start from {AB → C,BC → A,C → DE ,DE → B}
Step (2) Check whether FDs have only one attribute on the righthand side
thus we will have {AB → C,BC → A,C → D,C → E ,DE → B}
Step (3) Check whether any redundant attribute can be removed from the
left hand side of any FD
BC→ A can be reduced to C→ A because Σ |= C→ A.
Why AB→ C cannot be replaced by B→ C or A→ C? etc.
(Refer to Slides 31-32 in Week 5 workshop)
Step (4) Check if there are any redundant FDs (all good).
The Minimal cover is {AB → C,C → A,C → D,C → E ,DE → B}
23/26
Assignment 2 – Q2
Minimal Cover Main steps:
Step (1) Start from {AB → C,BC → A,C → DE ,DE → B}
Step (2) Check whether FDs have only one attribute on the righthand side
thus we will have {AB → C,BC → A,C → D,C → E ,DE → B}
Step (3) Check whether any redundant attribute can be removed from the
left hand side of any FD
BC→ A can be reduced to C→ A because Σ |= C→ A.
Why AB→ C cannot be replaced by B→ C or A→ C? etc.
(Refer to Slides 31-32 in Week 5 workshop)
Step (4) Check if there are any redundant FDs (all good).
The Minimal cover is {AB → C,C → A,C → D,C → E ,DE → B}
23/26
Assignment 2 – Q2
Minimal Cover Main steps:
Step (1) Start from {AB → C,BC → A,C → DE ,DE → B}
Step (2) Check whether FDs have only one attribute on the righthand side
thus we will have {AB → C,BC → A,C → D,C → E ,DE → B}
Step (3) Check whether any redundant attribute can be removed from the
left hand side of any FD
BC→ A can be reduced to C→ A because Σ |= C→ A.
Why AB→ C cannot be replaced by B→ C or A→ C? etc.
(Refer to Slides 31-32 in Week 5 workshop)
Step (4) Check if there are any redundant FDs (all good).
The Minimal cover is {AB → C,C → A,C → D,C → E ,DE → B}
23/26
Assignment 2 – Q2
Minimal Cover Main steps:
Step (1) Start from {AB → C,BC → A,C → DE ,DE → B}
Step (2) Check whether FDs have only one attribute on the righthand side
thus we will have {AB → C,BC → A,C → D,C → E ,DE → B}
Step (3) Check whether any redundant attribute can be removed from the
left hand side of any FD
BC→ A can be reduced to C→ A because Σ |= C→ A.
Why AB→ C cannot be replaced by B→ C or A→ C? etc.
(Refer to Slides 31-32 in Week 5 workshop)
Step (4) Check if there are any redundant FDs (all good).
The Minimal cover is {AB → C,C → A,C → D,C → E ,DE → B}
23/26
Assignment 2 – Q2
Minimal Cover Main steps:
Step (1) Start from {AB → C,BC → A,C → DE ,DE → B}
Step (2) Check whether FDs have only one attribute on the righthand side
thus we will have {AB → C,BC → A,C → D,C → E ,DE → B}
Step (3) Check whether any redundant attribute can be removed from the
left hand side of any FD
BC→ A can be reduced to C→ A because Σ |= C→ A.
Why AB→ C cannot be replaced by B→ C or A→ C? etc.
(Refer to Slides 31-32 in Week 5 workshop)
Step (4) Check if there are any redundant FDs (all good).
The Minimal cover is {AB → C,C → A,C → D,C → E ,DE → B}
23/26
Assignment 2 – Q2
Minimal Cover Main steps:
Step (1) Start from {AB → C,BC → A,C → DE ,DE → B}
Step (2) Check whether FDs have only one attribute on the righthand side
thus we will have {AB → C,BC → A,C → D,C → E ,DE → B}
Step (3) Check whether any redundant attribute can be removed from the
left hand side of any FD
BC→ A can be reduced to C→ A because Σ |= C→ A.
Why AB→ C cannot be replaced by B→ C or A→ C? etc.
(Refer to Slides 31-32 in Week 5 workshop)
Step (4) Check if there are any redundant FDs (all good).
The Minimal cover is {AB → C,C → A,C → D,C → E ,DE → B}
23/26
Assignment 2 – Q2
Minimal Cover Main steps:
Step (1) Start from {AB → C,BC → A,C → DE ,DE → B}
Step (2) Check whether FDs have only one attribute on the righthand side
thus we will have {AB → C,BC → A,C → D,C → E ,DE → B}
Step (3) Check whether any redundant attribute can be removed from the
left hand side of any FD
BC→ A can be reduced to C→ A because Σ |= C→ A.
Why AB→ C cannot be replaced by B→ C or A→ C? etc.
(Refer to Slides 31-32 in Week 5 workshop)
Step (4) Check if there are any redundant FDs (all good).
The Minimal cover is {AB → C,C → A,C → D,C → E ,DE → B}
23/26
Assignment 2 – Q2
Minimal Cover Main steps:
Step (1) Start from {AB → C,BC → A,C → DE ,DE → B}
Step (2) Check whether FDs have only one attribute on the righthand side
thus we will have {AB → C,BC → A,C → D,C → E ,DE → B}
Step (3) Check whether any redundant attribute can be removed from the
left hand side of any FD
BC→ A can be reduced to C→ A because Σ |= C→ A.
Why AB→ C cannot be replaced by B→ C or A→ C? etc.
(Refer to Slides 31-32 in Week 5 workshop)
Step (4) Check if there are any redundant FDs (all good).
The Minimal cover is {AB → C,C → A,C → D,C → E ,DE → B}
23/26
Assignment 2 – Q2
Minimal Cover Main steps:
Step (1) Start from {AB → C,BC → A,C → DE ,DE → B}
Step (2) Check whether FDs have only one attribute on the righthand side
thus we will have {AB → C,BC → A,C → D,C → E ,DE → B}
Step (3) Check whether any redundant attribute can be removed from the
left hand side of any FD
BC→ A can be reduced to C→ A because Σ |= C→ A.
Why AB→ C cannot be replaced by B→ C or A→ C? etc.
(Refer to Slides 31-32 in Week 5 workshop)
Step (4) Check if there are any redundant FDs (all good).
The Minimal cover is {AB → C,C → A,C → D,C → E ,DE → B}
23/26
Assignment 2 – Q2
Minimal Cover Main steps:
Step (1) Start from {AB → C,BC → A,C → DE ,DE → B}
Step (2) Check whether FDs have only one attribute on the righthand side
thus we will have {AB → C,BC → A,C → D,C → E ,DE → B}
Step (3) Check whether any redundant attribute can be removed from the
left hand side of any FD
BC→ A can be reduced to C→ A because Σ |= C→ A.
Why AB→ C cannot be replaced by B→ C or A→ C? etc.
(Refer to Slides 31-32 in Week 5 workshop)
Step (4) Check if there are any redundant FDs (all good).
The Minimal cover is {AB → C,C → A,C → D,C → E ,DE → B}
24/26
Assignment 2 – Q3
Consider the relation schema APPOINTMENT={P, G, D, T, C, R}
and Σ = { PCD → T, P → G, G → C, CDTR → P, PDT → CR }.
Note that G → C is lost because it cannot be recovered (inferred)
by the surviving FDs in RA and RB.
24/26
Assignment 2 – Q3
Consider the relation schema APPOINTMENT={P, G, D, T, C, R}
and Σ = { PCD → T, P → G, G → C, CDTR → P, PDT → CR }.
Note that G → C is lost because it cannot be recovered (inferred)
by the surviving FDs in RA and RB.
25/26
Assignment 2 – Q4
STUDENT={SID, Name, Degree, College, Address, Phone} with the primary
key {SID},
COURSE={CourseNo, College, Semester} with the primary key {CourseNo,
Semester},
TUTOR={TID, Email, CourseNo, Semester} with the primary key {TID,
CourseNo, Semester} and the foreign keys:
[CourseNo,Semester]⊆COURSE[CourseNo,Semester] and
[TID]⊆STUDENT[SID],
ENROL={SID, CourseNo, Semester, Unit, Status} with the primary key
{SID, CourseNo, Semester} and the foreign keys:
[CourseNo,Semester]⊆COURSE[CourseNo,Semester] and
[SID]⊆STUDENT[SID].
Pay attention to keywords like never, only, always, exactly, etc. which
often indicate to use the set difference in the corresponding RA queries.
25/26
Assignment 2 – Q4
STUDENT={SID, Name, Degree, College, Address, Phone} with the primary
key {SID},
COURSE={CourseNo, College, Semester} with the primary key {CourseNo,
Semester},
TUTOR={TID, Email, CourseNo, Semester} with the primary key {TID,
CourseNo, Semester} and the foreign keys:
[CourseNo,Semester]⊆COURSE[CourseNo,Semester] and
[TID]⊆STUDENT[SID],
ENROL={SID, CourseNo, Semester, Unit, Status} with the primary key
{SID, CourseNo, Semester} and the foreign keys:
[CourseNo,Semester]⊆COURSE[CourseNo,Semester] and
[SID]⊆STUDENT[SID].
Pay attention to keywords like never, only, always, exactly, etc. which
often indicate to use the set difference in the corresponding RA queries.
26/26
Questions or Feedback?
The SELT is available in Wattle for you to have your say about
your learning experience in this course. This survey seeks
feedback about your experience in the entire duration of this
course, starting from the first week. We encourage you to
have your say as we are very keen to know your overall
experience in this course. Your anonymous feedback will help
us in planning future offerings of this course.
We value your feedback!