INF3707
EXAM PACK
FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739
, lOMoARcPSD|53028991
INF3707/NOV
UNIVERSITY EXAMINATIONS
NOV 2025
INF3707
DATABASE DESIGN AND IMPLEMENTATION
Welcome to the INF3707 exam.
Date: 05 November 2025
Time: 08:00 AM
Duration: 2 hours
Examiner name: Dr. B Chipangura
Internal moderator name: Prof. L Motsi
External moderator name: DR. N Zhakata
This paper consists of 11 pages and Annexture A with ii pages
Total marks: 100
Instructions:
• Download the Answer sheet template
• This is a closed-book exam.
• Answer all questions.
• The marks for each question are given in brackets next to the question.
• Answer the questions in order. If you want to answer a question later, leave a blank space.
• You are not allowed to use mobile devices, calculators, the Internet, or a MySQL database
to test your code during this exam.
• Verify that you have not received or received help with this examination.
• Students are required to use the IRIS invigilator.
Additional student instructions
1. Students must upload their answer scripts in a single PDF file (the answer scripts must not
be password protected or uploaded as “read only” files)
2. Incorrect file format and uncollated answer scripts will not be considered.
3. Email scripts will not be accepted.
4. Students are advised to preview submissions (answer scripts) to ensure legibility and that
the correct answer script file has been uploaded.
5. Incorrect answer scripts and/or submissions made on unofficial examination platforms
(including the invigilator cell phone application) will not be marked and no opportunity will
be granted for resubmission. Only the last answer file uploaded within the stipulated
submission duration period will be marked.
6. The mark awarded for incomplete submission will be the final mark of the student. No
opportunity for resubmission will be granted.
7. The mark awarded for an illegible scanned submission will be the final mark of the student.
No opportunity for resubmission will be granted.
8. Submissions will only be accepted from registered student accounts.
9. Students who have not used the proctoring tool will be deemed to have transgressed the
Unisa examination rules and will have their marks withheld. If a student is found to have
been outside the proctoring tool for a total of 10 minutes during their examination session,
they will be considered to have violated the Unisa examination rules and their marks will be
[Turn over]
Downloaded by Edger Tutora ()
, lOMoARcPSD|53028991
INF3707/NOV
withheld. For examinations using the IRIS invigilator system, IRIS must be recorded
throughout the duration of the examination until the submission of the examination scripts.
10. Students have 48 hours from the date of their examination to upload their IRIS invigilator
results. Failure to do so will result in students being deemed to have not used the
proctoring tools.
11. Students suspected of dishonest conduct during the examinations will be subjected to
disciplinary processes. Students may not communicate with anyone else or request help
from any other person during their examinations. Plagiarism is a violation of academic
integrity, and students who plagiarise, copy from published work or Artificial Intelligence
Software (e.g. ChatGPT) or online sources (e.g., course material), will be in violation of the
Policy on Academic Integrity and the Student Disciplinary Code and may be referred to a
disciplinary hearing. Unisa has zero tolerance for plagiarism and/or any other forms of
academic dishonesty.
12. Listening to audio (music) and using audio-to-text software is strictly prohibited during your
examination session unless such usage of the software is related to a student’s assistive
device that has been declared. Failure to do so will be a transgression of the Unisa
examination rules and the student's marks will be withheld.
13. Students have 30 minutes to submit their answer scripts after the official examination time.
Students who experience technical challenges should report the challenges to the SCSC
on 080 000 1870 or their College exam support centres (refer to Get help during the
examinations by contacting the Student Communication Service Centre [unisa.ac.za])
within 30 minutes. Queries received after 30 minutes of the official examination duration
time will not be responded to. Submissions made after the official examination time will be
rejected according to the examination regulations and will not be marked. Only
communication received from your myLife account will be considered.
14. Nonadherence to the processes for uploading examination responses will not qualify the
student for any special concessions or future assessments.
15. Queries that are beyond Unisa’s control include the following: a. Personal network or
service provider issues
b. Load shedding/limited space on a personal computer
c. Crashed computer
d. Non-functioning cameras or web cameras.
e. Using work computers that block access to the myExams site (employer firewall
challenges)
f. Unlicensed software (e.g. licence expires during exams)
Students experiencing the above challenges are advised to apply for an aegrotat and
submit supporting evidence within ten days of the examination session. Students will not
be able to apply for an aegrotat for a third examination opportunity.
Postgraduate/undergraduate students experiencing the above challenges in their second
examination opportunity will have to reregister for the affected module.
16. Students suspected of dishonest conduct during the examinations will be subjected to
disciplinary processes. UNISA has zero tolerance for plagiarism and/or any other forms of
academic dishonesty.
17. Students experiencing network or load-shedding challenges are advised to apply together
with supporting evidence for an Aegrotat within 3 days of the examination session.
2
[Turn over]
Downloaded by Edger Tutora ()
, lOMoARcPSD|53028991
INF3707/NOV
Question 1 [40 marks]
• Choose the correct answer.
• Write down the correct answer next to the question number (for example: 1.1. D) in your examination
book. Download the answer sheet template provided on the exam’s portal.
• It is compulsory to use the answer book.
• Annexture A, at the end of this document, containts table description and data for tables: INVOICES,
VENDORS and INVOICE_LINE_ITEMS
• Questions that may require you to reference Annexture A are: 1.5, 1.8 and 1.9.
Question 1.1:
If a SELECT statement has a FROM, GROUP BY, WHERE, HAVING, and ORDER BY, which is the correct
order in which they are processed. (2 marks)
A. SELECT, FROM, GROUP BY, HAVING, WHERE, ORDER BY
B. SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING
C. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
D. SELECT, FROM, ORDER BY, WHERE, GROUP BY, HAVING
Question 1.2:
Which clause is used to suppress duplicates in a SELECT statement? Choose the best answer. (2 marks)
A. INTERSECT ALL
B. DUPLICATE
C. DISTINCT
D. UNION ALL
Question 1.3:
If you assign an alias to one table when joining tables, you must (2 marks)
A. assign alias to all the tables
B. use that alias to refer to the table throughout your query
C. qualify every column name in the query
D qualify all of the column names for that table
Question 1.4:
Which of the following expressions does not compute 10% of the balance due, where balance due is the invoice
total minus the credit total minus the payment total? (3 marks)
A. invoice_total - credit_total - payment_total / 10
B. (invoice_total - payment_total - credit_total) / 10
C. (invoice_total - (payment_total + credit_total)) * 0.10
D. ((invoice_total - payment_total) - credit_total) / 10
3
[Turn over]
Downloaded by Edger Tutora ()
EXAM PACK
FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739
, lOMoARcPSD|53028991
INF3707/NOV
UNIVERSITY EXAMINATIONS
NOV 2025
INF3707
DATABASE DESIGN AND IMPLEMENTATION
Welcome to the INF3707 exam.
Date: 05 November 2025
Time: 08:00 AM
Duration: 2 hours
Examiner name: Dr. B Chipangura
Internal moderator name: Prof. L Motsi
External moderator name: DR. N Zhakata
This paper consists of 11 pages and Annexture A with ii pages
Total marks: 100
Instructions:
• Download the Answer sheet template
• This is a closed-book exam.
• Answer all questions.
• The marks for each question are given in brackets next to the question.
• Answer the questions in order. If you want to answer a question later, leave a blank space.
• You are not allowed to use mobile devices, calculators, the Internet, or a MySQL database
to test your code during this exam.
• Verify that you have not received or received help with this examination.
• Students are required to use the IRIS invigilator.
Additional student instructions
1. Students must upload their answer scripts in a single PDF file (the answer scripts must not
be password protected or uploaded as “read only” files)
2. Incorrect file format and uncollated answer scripts will not be considered.
3. Email scripts will not be accepted.
4. Students are advised to preview submissions (answer scripts) to ensure legibility and that
the correct answer script file has been uploaded.
5. Incorrect answer scripts and/or submissions made on unofficial examination platforms
(including the invigilator cell phone application) will not be marked and no opportunity will
be granted for resubmission. Only the last answer file uploaded within the stipulated
submission duration period will be marked.
6. The mark awarded for incomplete submission will be the final mark of the student. No
opportunity for resubmission will be granted.
7. The mark awarded for an illegible scanned submission will be the final mark of the student.
No opportunity for resubmission will be granted.
8. Submissions will only be accepted from registered student accounts.
9. Students who have not used the proctoring tool will be deemed to have transgressed the
Unisa examination rules and will have their marks withheld. If a student is found to have
been outside the proctoring tool for a total of 10 minutes during their examination session,
they will be considered to have violated the Unisa examination rules and their marks will be
[Turn over]
Downloaded by Edger Tutora ()
, lOMoARcPSD|53028991
INF3707/NOV
withheld. For examinations using the IRIS invigilator system, IRIS must be recorded
throughout the duration of the examination until the submission of the examination scripts.
10. Students have 48 hours from the date of their examination to upload their IRIS invigilator
results. Failure to do so will result in students being deemed to have not used the
proctoring tools.
11. Students suspected of dishonest conduct during the examinations will be subjected to
disciplinary processes. Students may not communicate with anyone else or request help
from any other person during their examinations. Plagiarism is a violation of academic
integrity, and students who plagiarise, copy from published work or Artificial Intelligence
Software (e.g. ChatGPT) or online sources (e.g., course material), will be in violation of the
Policy on Academic Integrity and the Student Disciplinary Code and may be referred to a
disciplinary hearing. Unisa has zero tolerance for plagiarism and/or any other forms of
academic dishonesty.
12. Listening to audio (music) and using audio-to-text software is strictly prohibited during your
examination session unless such usage of the software is related to a student’s assistive
device that has been declared. Failure to do so will be a transgression of the Unisa
examination rules and the student's marks will be withheld.
13. Students have 30 minutes to submit their answer scripts after the official examination time.
Students who experience technical challenges should report the challenges to the SCSC
on 080 000 1870 or their College exam support centres (refer to Get help during the
examinations by contacting the Student Communication Service Centre [unisa.ac.za])
within 30 minutes. Queries received after 30 minutes of the official examination duration
time will not be responded to. Submissions made after the official examination time will be
rejected according to the examination regulations and will not be marked. Only
communication received from your myLife account will be considered.
14. Nonadherence to the processes for uploading examination responses will not qualify the
student for any special concessions or future assessments.
15. Queries that are beyond Unisa’s control include the following: a. Personal network or
service provider issues
b. Load shedding/limited space on a personal computer
c. Crashed computer
d. Non-functioning cameras or web cameras.
e. Using work computers that block access to the myExams site (employer firewall
challenges)
f. Unlicensed software (e.g. licence expires during exams)
Students experiencing the above challenges are advised to apply for an aegrotat and
submit supporting evidence within ten days of the examination session. Students will not
be able to apply for an aegrotat for a third examination opportunity.
Postgraduate/undergraduate students experiencing the above challenges in their second
examination opportunity will have to reregister for the affected module.
16. Students suspected of dishonest conduct during the examinations will be subjected to
disciplinary processes. UNISA has zero tolerance for plagiarism and/or any other forms of
academic dishonesty.
17. Students experiencing network or load-shedding challenges are advised to apply together
with supporting evidence for an Aegrotat within 3 days of the examination session.
2
[Turn over]
Downloaded by Edger Tutora ()
, lOMoARcPSD|53028991
INF3707/NOV
Question 1 [40 marks]
• Choose the correct answer.
• Write down the correct answer next to the question number (for example: 1.1. D) in your examination
book. Download the answer sheet template provided on the exam’s portal.
• It is compulsory to use the answer book.
• Annexture A, at the end of this document, containts table description and data for tables: INVOICES,
VENDORS and INVOICE_LINE_ITEMS
• Questions that may require you to reference Annexture A are: 1.5, 1.8 and 1.9.
Question 1.1:
If a SELECT statement has a FROM, GROUP BY, WHERE, HAVING, and ORDER BY, which is the correct
order in which they are processed. (2 marks)
A. SELECT, FROM, GROUP BY, HAVING, WHERE, ORDER BY
B. SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING
C. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
D. SELECT, FROM, ORDER BY, WHERE, GROUP BY, HAVING
Question 1.2:
Which clause is used to suppress duplicates in a SELECT statement? Choose the best answer. (2 marks)
A. INTERSECT ALL
B. DUPLICATE
C. DISTINCT
D. UNION ALL
Question 1.3:
If you assign an alias to one table when joining tables, you must (2 marks)
A. assign alias to all the tables
B. use that alias to refer to the table throughout your query
C. qualify every column name in the query
D qualify all of the column names for that table
Question 1.4:
Which of the following expressions does not compute 10% of the balance due, where balance due is the invoice
total minus the credit total minus the payment total? (3 marks)
A. invoice_total - credit_total - payment_total / 10
B. (invoice_total - payment_total - credit_total) / 10
C. (invoice_total - (payment_total + credit_total)) * 0.10
D. ((invoice_total - payment_total) - credit_total) / 10
3
[Turn over]
Downloaded by Edger Tutora ()
