INF3707
EXAM PACK
Recent exam questions and answers
Summarised study notes
Exam tips and guidelines
+27 81 278 3372
DISCLAIMER & TERMS OF USE
1. Educational Aid: These study notes are designed to serve as educational aids and should not be considered as a
substitute for individual research, critical thinking, or professional guidance. Students are encouraged to
conduct their own extensive research and consult with their instructors or academic advisors for specific
assignment requirements.
2. Personal Responsibility: While every effort has been made to ensure the accuracy and reliability of the
information provided in these study notes, the seller cannot guarantee the completeness or correctness of all
the content. It is the responsibility of the buyer to verify the accuracy of the information and use their own
judgment when applying it to their assignments.
3. Academic Integrity: It is crucial for students to uphold academic integrity and adhere to their institution's
policies and guidelines regarding plagiarism, citation, and referencing. These study notes should be used as a
tool for learning and inspiration, but any direct reproduction of the content without proper acknowledgment and
citation may constitute academic misconduct.
4. Limited Liability: The seller of these study notes shall not be held liable for any direct or indirect damages,
losses, or consequences arising from the use of the notes. This includes, but is not limited to, poor grades,
academic penalties, or any other negative outcomes resulting from the application or misuse of the information
provide
]
, INF3707/OCT
UNIVERSITY EXAMINATIONS
OCTOBER 2024
INF3707
DATABASE DESIGN AND IMPLEMENTATION
Welcome to the INF3707 exam.
Date: 31 October 2024
Time: 08:00
Hours: 2hrs
Examiner name: Dr. B Chipangura
Internal moderator name: Dr. L Motsi
External moderator name: Ms. V Booi
This paper consists of 9 pages and Annexture A with 4 pages (i-iv)
Total marks: 100
Instructions:
• This paper has Annexture A containing the JustLee database tables.
• 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 Oracle XE during
this exam.
• Pledge that you have not given or received aid on this examination (You must respond to
this pledge when submitting your assignment.)
• Students are required to use the IRIS invigilator.
Additional student instructions
1. Students must upload their answer scripts in a single PDF file (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 student’s final mark. No
opportunity for resubmission will be granted.
7. The mark awarded for illegible scanned submission will be the student’s final mark. 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]
, INF3707/OCT
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 deemed to have not utilised the proctoring
tools.
11. Students suspected of dishonest conduct during the examinations will be subjected to
disciplinary processes. Students may not communicate with any other person or request
assistance 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 (eg ChatGPT) or online sources (eg 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 (eg 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]
, INF3707/OCT
Question 1: Multiple choice questions
• Choose the correct answer. The marks for each question are given in brackets next to the
question.
• Write down the question number and the letter of the correct answer (for example 1. 1 B) in
your examination book.
Question 1.1:
When you code a calculated value in a SELECT clause, the expression for the calculated value can
include which of the following. (2 marks)
A. arithmetic operators only
B. arithmetic operators and functions only
C. arithmetic operators, comparison operators, and functions only
D. arithmetic operators, comparison operators, logical operators,
and functions
Question 1.2:
Assume that the Books table has a column named Cost. Which of the following SELECT clauses
would you use to assign an alias for calculating the total cost of books? (2 marks)
A. SELECT cost LIKE total from Books;
C. SELECT cost AS total from Books;
D. SELECT cost:total from books;
D. SELECT cost(invoice_total) from Books
Question 1.3:
In a join, column names need to be qualified only. (2 marks)
A. in inner joins
B. in outer joins
C. when the code is confusing
D. when the same column names exist in both tables
Question 1.4:
Which of the following statements is not true about the USING keyword? (2 marks)
A. you use it to simplify the syntax for joining tables
B. you code a USING clause in addition to an ON clause
C. it can be used with inner or outer joins
D. the join must be an equijoin
3
[Turn over]
