INF2603
EXAM PACK
FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739
,UNIVERSITY EXAMINATIONS
OCTOBER/NOVEMBER 2023
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 2023
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. 11. (e)) (2 marks each):
1. The _____ is actually a system-created database whose tables store the
user/designer-created database characteristics and contents.
a. unique index
b. database tuple
c. system catalogue
d. systematic database
2. Within the relational model, tables are known as ____, columns of tables are referred
to as ____ and rows of tables are called ____.
a. tuples, attributes, entities
b. relations, attributes, tuples
c. relations, tuples, attributes
d. relation, attributes, tuples
3. Which of the following returns all tuples in one relation that are not found in the other
relation?
a. PRODUCT
b. SELECT
c. PROJECT
d. DIFFERENCE
4. The STUDENT table’s primary key is STUDENT_NUMB. The STUDENT primary key
column has no null entries, and all entries are unique. This is an example of _____
integrity.
a. null
b. entity
c. relational
d. referential
5. Which of the following is true of NoSQL databases?
a. They do not support distributed database architectures.
b. They are not based on the relational model.
c. They are geared toward transaction consistency rather than performance.
d. They do not support very large amounts of sparse data.
6. 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.
TURN OVER
, 3
INF2603
OCTOBER/NOVEMBER 2023
7. 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
8.The Chen notation identifies a weak entity by using a double-walled entity rectangle.
a. True
b. False
9. Which of the following special operator checks whether an attribute value matches any
value within a value list?
a. IN
b. LIKE
c. EXISTS
d. BETWEEN
10. If the attribute (A) is functionally dependent on a composite key (B) but not on any
subset of that composite key, the attribute (A) is fully functionally dependent on (B).
a. True
b. False
QUESTION 2 [15 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,
example =1 mark):
a. Atomic attribute
b. Recursive relationships
c. Disjoint subtypes
d. Granularity
e. OODM (object-oriented data model)
QUESTION 3 [12 marks]
a. Describe the entity-relationship model. How are entities, relationships, and attributes
represented in this model? What is a composite entity? Describe the approach to
diagrams that use a crow’s foot or UML. Describe how you would represent cardinality
in an E-R diagram. (12)
TURN OVER
EXAM PACK
FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739
,UNIVERSITY EXAMINATIONS
OCTOBER/NOVEMBER 2023
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 2023
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. 11. (e)) (2 marks each):
1. The _____ is actually a system-created database whose tables store the
user/designer-created database characteristics and contents.
a. unique index
b. database tuple
c. system catalogue
d. systematic database
2. Within the relational model, tables are known as ____, columns of tables are referred
to as ____ and rows of tables are called ____.
a. tuples, attributes, entities
b. relations, attributes, tuples
c. relations, tuples, attributes
d. relation, attributes, tuples
3. Which of the following returns all tuples in one relation that are not found in the other
relation?
a. PRODUCT
b. SELECT
c. PROJECT
d. DIFFERENCE
4. The STUDENT table’s primary key is STUDENT_NUMB. The STUDENT primary key
column has no null entries, and all entries are unique. This is an example of _____
integrity.
a. null
b. entity
c. relational
d. referential
5. Which of the following is true of NoSQL databases?
a. They do not support distributed database architectures.
b. They are not based on the relational model.
c. They are geared toward transaction consistency rather than performance.
d. They do not support very large amounts of sparse data.
6. 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.
TURN OVER
, 3
INF2603
OCTOBER/NOVEMBER 2023
7. 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
8.The Chen notation identifies a weak entity by using a double-walled entity rectangle.
a. True
b. False
9. Which of the following special operator checks whether an attribute value matches any
value within a value list?
a. IN
b. LIKE
c. EXISTS
d. BETWEEN
10. If the attribute (A) is functionally dependent on a composite key (B) but not on any
subset of that composite key, the attribute (A) is fully functionally dependent on (B).
a. True
b. False
QUESTION 2 [15 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,
example =1 mark):
a. Atomic attribute
b. Recursive relationships
c. Disjoint subtypes
d. Granularity
e. OODM (object-oriented data model)
QUESTION 3 [12 marks]
a. Describe the entity-relationship model. How are entities, relationships, and attributes
represented in this model? What is a composite entity? Describe the approach to
diagrams that use a crow’s foot or UML. Describe how you would represent cardinality
in an E-R diagram. (12)
TURN OVER
