, INF2603
EXAM PACK
CONTAINS LATEST
QUESTIONS
AND
ANSWERS
L
, lOMoAR cPSD| 47654148
UNIVERSITY EXAMINATIONS
JANUARY/FEBRUARY 2024
INF2603
Database 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms CL Hlengwa
This paper consists of 7 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. This final pdf document should not be password protected.
6. Convert all the pages into a single PDF file.
7. Poorly scanned and hard to read answer files will result in a zero mark.
8. Once your document meets all the criteria, then you can upload the file to myAdmin.
Downloaded
by Tonnie Ochieng ()
, lOMoAR cPSD| 47654148
2
INF2603
JANUARY/FEBRUARY 2024
QUESTION 1 [25 marks]
Carefully select the most correct answer to each of the following
questions. Please write down only the question number and
corresponding to it put the correct option s number (e.g. Qu. 11. (e)):
For question 1 to 5: Indicate whether the statement is true or false. (1
mark each):
1. M:N relationships are not appropriate in a relational model.
a. True
b. False
2. In SQL terms, union-compatible means that the names of the table
attributes must be the same and their data types must be identical.
a. True
b. False
3. Structural dependence exists when it is possible to make changes
in the file structure without affecting the application program’s
ability to access the data. a. True
b. False
4. A weak relationship exists if the primary key of the related entity
contains at least one primary key component of the parent entity.
a. True
b. False
TURN OVER
Downloaded by Tonnie Ochieng ()
EXAM PACK
CONTAINS LATEST
QUESTIONS
AND
ANSWERS
L
, lOMoAR cPSD| 47654148
UNIVERSITY EXAMINATIONS
JANUARY/FEBRUARY 2024
INF2603
Database 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms CL Hlengwa
This paper consists of 7 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. This final pdf document should not be password protected.
6. Convert all the pages into a single PDF file.
7. Poorly scanned and hard to read answer files will result in a zero mark.
8. Once your document meets all the criteria, then you can upload the file to myAdmin.
Downloaded
by Tonnie Ochieng ()
, lOMoAR cPSD| 47654148
2
INF2603
JANUARY/FEBRUARY 2024
QUESTION 1 [25 marks]
Carefully select the most correct answer to each of the following
questions. Please write down only the question number and
corresponding to it put the correct option s number (e.g. Qu. 11. (e)):
For question 1 to 5: Indicate whether the statement is true or false. (1
mark each):
1. M:N relationships are not appropriate in a relational model.
a. True
b. False
2. In SQL terms, union-compatible means that the names of the table
attributes must be the same and their data types must be identical.
a. True
b. False
3. Structural dependence exists when it is possible to make changes
in the file structure without affecting the application program’s
ability to access the data. a. True
b. False
4. A weak relationship exists if the primary key of the related entity
contains at least one primary key component of the parent entity.
a. True
b. False
TURN OVER
Downloaded by Tonnie Ochieng ()
