UNIVERSITY EXAMINATIONS
OCTOBER/NOVEMBER 2021
INF2603
Database 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms CL Hlengwa
This paper consists of 4 pages.
Instructions:
1. Answer all questions.
2. The marks for each question are given in brackets next to the question.
3. Please answer the questions in the order in which they have been set.
4. You signed an Honesty Declaration. This means you will complete this paper on your
own and without help.
5. You may use your prescribed textbook.
6. This final pdf document should not be password protected.
7. Convert all the pages into a single PDF file.
8. Poorly scanned and hard to read answer files will result in a zero mark.
9. Incorrect file format and uncollated answer scripts will not be considered.
10. NO emailed scripts will be accepted.
11. You are advised to preview submissions (answer scripts) to ensure legibility and that
the correct answer script file has been uploaded.
12. Incorrect answer scripts and/or submissions made on unofficial examinations
platforms will not be marked and no opportunity will be granted for resubmission.
13. Mark awarded for incomplete submission will be the student’s final mark. No
opportunity for resubmission will be granted.
14. Mark awarded for illegible scanned submission will be the student’s final mark. No
opportunity for resubmission will be granted.
15. Submissions will only be accepted from registered student accounts.
GOOD LUCK.
, 2
INF2603
October/November 2021
QUESTION 1 [18 marks]
Briefly explain what is meant by each of the following terms in a database design context and
provide an example. Do not copy examples from the book. (explanation = 2 marks, example
=1 mark):
a. NoSQL
b. OODM (object-oriented data model)
c. Codd’ relational database rules
d. Atomic attribute
e. Recursive relationships
f. Disjoint subtypes
QUESTION 2 [11 marks]
a. What does the term 3 Vs refer to? (3)
b. What primary key characteristics are considered desirable? Explain why each
characteristic is considered desirable. (6)
nd
c. Define 2 normal form. What type of problems would you find in tables that are not in
2nd normal form? (2)
QUESTION 3 [20 marks]
a. Given the dependency diagram shown in Figure 3.1 answer items 3i-3iii:
FIGURE 3.1 Dependency Diagram
i. Identify and discuss each of the indicated dependencies. (6)
ii. Create a database whose tables are at least in 2NF, showing the dependency diagrams
for each table. (7)
iii. Create a database whose tables are at least in 3NF, showing the dependency diagrams
for each table. (7)
TURN OVER
, 3
INF2603
October/November 2021
QUESTION 4 [20 marks]
a. Given the following business rules, create an initial ERD using Crow’s Foot notation.
Show all entities, relationships, connectivities, and cardinalities.
i. A musician makes at least one recording,but may over a period of time make many
recordings.
ii. One recording consists of at least 3 or more tracks.
iii. A track can appear on more than one recording.
QUESTION 5 [31 marks]
Consider the following relation:
ARTICLES (NUMBER, TITLE, PUBLICATION, VOLUME, YEAR, STARTPAGE, ENDPAGE,
TECHNICAL_REPORT_ID)
The relation contains information on articles published in publications (Journals). Each article
has a unique number, title, and information on where to find it (name of the publication, what
volume, and on which pages is appearing), also the ID of the technical report is specified.
The following is an illustration of the relation:
NUMBER TITLE PUBLICATION VOLUME YEAR STARTPAGE ENDPAGE TECHNICAL_REPORT_ID
240 Junior PC games SAJS 15 2019 141 153 87
330 Early Childwood SAJS 14 2016 79 95 26
330 Early Childwood SAJS 14 2016 79 95 65
930 Data Dictionary SAJEMS 13 2016 211 233 74
750 P_value vs SACJ 15 2020 1 4 99
Equilibriam
solved
770 Data missed SAJEMS 15 2020 1 6 89
870 Data missed Nature 3333 2020 33 33 89
a. Based on the information provided, indicate for each of the following sets of attributes
whether it is a key for Articles or NOT. Please write down only question number and
corresponding to it put the correct option (e.g.: 7. Not a key) (1 mark for each) (6)
1. {NUMBER}
2. {NUMBER, TECHNICAL_REPORT_ID}
3. {TITLE}
4. {TITLE, YEAR}
5. {STARTPAGE, PUBLICATION, VOLUME}
6. {NUMBER, TITLE, TECHNICAL_REPORT_ID}
TURN OVER
OCTOBER/NOVEMBER 2021
INF2603
Database 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms CL Hlengwa
This paper consists of 4 pages.
Instructions:
1. Answer all questions.
2. The marks for each question are given in brackets next to the question.
3. Please answer the questions in the order in which they have been set.
4. You signed an Honesty Declaration. This means you will complete this paper on your
own and without help.
5. You may use your prescribed textbook.
6. This final pdf document should not be password protected.
7. Convert all the pages into a single PDF file.
8. Poorly scanned and hard to read answer files will result in a zero mark.
9. Incorrect file format and uncollated answer scripts will not be considered.
10. NO emailed scripts will be accepted.
11. You are advised to preview submissions (answer scripts) to ensure legibility and that
the correct answer script file has been uploaded.
12. Incorrect answer scripts and/or submissions made on unofficial examinations
platforms will not be marked and no opportunity will be granted for resubmission.
13. Mark awarded for incomplete submission will be the student’s final mark. No
opportunity for resubmission will be granted.
14. Mark awarded for illegible scanned submission will be the student’s final mark. No
opportunity for resubmission will be granted.
15. Submissions will only be accepted from registered student accounts.
GOOD LUCK.
, 2
INF2603
October/November 2021
QUESTION 1 [18 marks]
Briefly explain what is meant by each of the following terms in a database design context and
provide an example. Do not copy examples from the book. (explanation = 2 marks, example
=1 mark):
a. NoSQL
b. OODM (object-oriented data model)
c. Codd’ relational database rules
d. Atomic attribute
e. Recursive relationships
f. Disjoint subtypes
QUESTION 2 [11 marks]
a. What does the term 3 Vs refer to? (3)
b. What primary key characteristics are considered desirable? Explain why each
characteristic is considered desirable. (6)
nd
c. Define 2 normal form. What type of problems would you find in tables that are not in
2nd normal form? (2)
QUESTION 3 [20 marks]
a. Given the dependency diagram shown in Figure 3.1 answer items 3i-3iii:
FIGURE 3.1 Dependency Diagram
i. Identify and discuss each of the indicated dependencies. (6)
ii. Create a database whose tables are at least in 2NF, showing the dependency diagrams
for each table. (7)
iii. Create a database whose tables are at least in 3NF, showing the dependency diagrams
for each table. (7)
TURN OVER
, 3
INF2603
October/November 2021
QUESTION 4 [20 marks]
a. Given the following business rules, create an initial ERD using Crow’s Foot notation.
Show all entities, relationships, connectivities, and cardinalities.
i. A musician makes at least one recording,but may over a period of time make many
recordings.
ii. One recording consists of at least 3 or more tracks.
iii. A track can appear on more than one recording.
QUESTION 5 [31 marks]
Consider the following relation:
ARTICLES (NUMBER, TITLE, PUBLICATION, VOLUME, YEAR, STARTPAGE, ENDPAGE,
TECHNICAL_REPORT_ID)
The relation contains information on articles published in publications (Journals). Each article
has a unique number, title, and information on where to find it (name of the publication, what
volume, and on which pages is appearing), also the ID of the technical report is specified.
The following is an illustration of the relation:
NUMBER TITLE PUBLICATION VOLUME YEAR STARTPAGE ENDPAGE TECHNICAL_REPORT_ID
240 Junior PC games SAJS 15 2019 141 153 87
330 Early Childwood SAJS 14 2016 79 95 26
330 Early Childwood SAJS 14 2016 79 95 65
930 Data Dictionary SAJEMS 13 2016 211 233 74
750 P_value vs SACJ 15 2020 1 4 99
Equilibriam
solved
770 Data missed SAJEMS 15 2020 1 6 89
870 Data missed Nature 3333 2020 33 33 89
a. Based on the information provided, indicate for each of the following sets of attributes
whether it is a key for Articles or NOT. Please write down only question number and
corresponding to it put the correct option (e.g.: 7. Not a key) (1 mark for each) (6)
1. {NUMBER}
2. {NUMBER, TECHNICAL_REPORT_ID}
3. {TITLE}
4. {TITLE, YEAR}
5. {STARTPAGE, PUBLICATION, VOLUME}
6. {NUMBER, TITLE, TECHNICAL_REPORT_ID}
TURN OVER
