UNIVERSITY EXAMINATIONS
OCTOBER/NOVEMBER 2022
INF2603
Database 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms CL Hlengwa
This paper consists of 5 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.
GOOD LUCK.
, 2
INF2603
October/November 2022
QUESTION 1 [20 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. 1 (e)).
1. Which of the following is NOT a true statement about constraints:
a. Constraints are important because they help to ensure data integrity.
b. Constraints support high-level inserts, updates and deletes.
c. Constraints are normally expressed in the form of rules.
d. A constraint is a restriction placed on the data.
2. The logical view of the relational database is facilitated by the ____.
a. objects defined by the database wizard
b. file system used by the operating system
c. creation of queries using the database wizard
d. creation of data relationships based on a construct known as a table
3. ______ is a common term used in traditional entity relationship modelling, and is used to express
the maximum number of entity occurrences associated with one occurrence of the related entity.
a. Participation
b. Cardinality
c. Multiplicity
d. Association
4. What is the purpose of an entity cluster?
a. define physical database storage for related entities
b. group related entities into a single table
c. improve readability of the ERD
d. make the ERD more complex
5. A query language is a procedural language.
a. True
b. False
6. Business rules apply to businesses and government groups, but not to other types of organisations
such as religious groups or research laboratories.
c. True
d. False
7. In the object-oriented data model (OODM), both data and their relationships are contained in a single
structure known as a(n) ____.
a. entity
b. attribute
c. Constraint
d. Object.
TURN OVER
OCTOBER/NOVEMBER 2022
INF2603
Database 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms CL Hlengwa
This paper consists of 5 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.
GOOD LUCK.
, 2
INF2603
October/November 2022
QUESTION 1 [20 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. 1 (e)).
1. Which of the following is NOT a true statement about constraints:
a. Constraints are important because they help to ensure data integrity.
b. Constraints support high-level inserts, updates and deletes.
c. Constraints are normally expressed in the form of rules.
d. A constraint is a restriction placed on the data.
2. The logical view of the relational database is facilitated by the ____.
a. objects defined by the database wizard
b. file system used by the operating system
c. creation of queries using the database wizard
d. creation of data relationships based on a construct known as a table
3. ______ is a common term used in traditional entity relationship modelling, and is used to express
the maximum number of entity occurrences associated with one occurrence of the related entity.
a. Participation
b. Cardinality
c. Multiplicity
d. Association
4. What is the purpose of an entity cluster?
a. define physical database storage for related entities
b. group related entities into a single table
c. improve readability of the ERD
d. make the ERD more complex
5. A query language is a procedural language.
a. True
b. False
6. Business rules apply to businesses and government groups, but not to other types of organisations
such as religious groups or research laboratories.
c. True
d. False
7. In the object-oriented data model (OODM), both data and their relationships are contained in a single
structure known as a(n) ____.
a. entity
b. attribute
c. Constraint
d. Object.
TURN OVER
