INF2603
EXAM PACK
Recent exam questions and answers
Summarised study notes
Exam tips and guidelines
+27 81 278 3372
DISCLAIMER & TERMS OF USE
Educational Aid: These study notes are intended to be used as educational resources and should not be seen as a
replacement for individual research, critical analysis, or professional consultation. Students are encouraged to perform
their own research and seek advice from their instructors or academic advisors for specific assignment guidelines.
Personal Responsibility: While every effort has been made to ensure the accuracy and reliability of the information in
these study notes, the seller does not guarantee the completeness or correctness of all content. The buyer is
responsible for verifying the accuracy of the information and exercising their own judgment when applying it to their
assignments.
Academic Integrity: It is essential for students to maintain academic integrity and follow their institution's policies
regarding plagiarism, citation, and referencing. These study notes should be used as learning tools and sources of
inspiration. Any direct reproduction of the content without proper citation and acknowledgment may be considered
academic misconduct.
Limited Liability: The seller shall not be liable for any direct or indirect damages, losses, or consequences arising from
the use of these notes. This includes, but is not limited to, poor academic performance, penalties, or any other negative
consequences resulting from the application or misuse of the information provided.
,UNIVERSITY EXAMINATIONS
OCTOBER/NOVEMBER 2025
INF2603
Databases 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms A Mukhithi
This paper consists of 6 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
cset.myexams.unisa.ac.za.
GOOD LUCK.
, 2
INF2603
OCTOBER /NOVEMBER 2025
QUESTION 1 [18 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.If CUSTOMER and INVOICE is classified as a 1:M and one direction would specify
that a CUSTOMER may generate many INVOICEs, what would be true of the
opposite direction?
a. CUSTOMER is unique to many INVOICEs
b. Each INVOICE is generated by one CUSTOMER
c. Each INVOICE is written to many CUSTOMERs
d. CUSTOMERs are given INVOICEs
2.Use the SQL statement ____ when trying to reference two tables for which data
columns must be updated to reflect the current list of a MASTERINVENTORY, for
example.
a. WHERE MASTERINVENTORY.PROD_ID = PRODSALES.PROD_ID
b. SET MASTERINVENTORY.PROD_ID = PRODSALES.PROD_ID
c. UPDATE MASTERINVENTORY.PROD_ID = PRODSALES.PROD_ID
d. JOIN MASTERINVENTORY.PROD_ID = PRODSALES.PROD_ID
3. What type of dependency is shown during normalization, if the conversion to the
second normal form involves removing all attributes dependent on only a part of a
composite primary key?
a. functional dependency
b. transitive dependency
c. partial dependency
d. primary key dependency
4. A subtype contains attributes that are common to all of its supertypes.
a. True
b. False
TURN OVER
, 3
INF2603
OCTOBER /NOVEMBER 2025
5. To eliminate repeating groups and convert a table into the first normal form (1NF),
what can you change in a table to convert multivalued attributes into single-valued
attributes?
a. primary key
b. dependency
c. business rules
d. focus
6. You are designing a conceptual model and are in the process of matching the
DBMS requirements to the entity-relationship diagram (ERD) to create a data model
that is software-independent. Which stage of the design phase are you doing?
a. internal schema
b. logical design
c. external model
d. physical independence
7. The main goal of normalization is to eliminate _________.
a. dependencies
b. data anomalies
c. repeating group
d. nonkey attributes
8. What do you add to the supertype table for a disjoint condition?
a. disjoint discriminator
b. supertype discriminator
c. subtype discriminator
d. joint discriminator
9. Rows can be grouped into smaller collections quickly and easily using the
COUNT clause within the SELECT statement.
a. True
b. False
TURN OVER
EXAM PACK
Recent exam questions and answers
Summarised study notes
Exam tips and guidelines
+27 81 278 3372
DISCLAIMER & TERMS OF USE
Educational Aid: These study notes are intended to be used as educational resources and should not be seen as a
replacement for individual research, critical analysis, or professional consultation. Students are encouraged to perform
their own research and seek advice from their instructors or academic advisors for specific assignment guidelines.
Personal Responsibility: While every effort has been made to ensure the accuracy and reliability of the information in
these study notes, the seller does not guarantee the completeness or correctness of all content. The buyer is
responsible for verifying the accuracy of the information and exercising their own judgment when applying it to their
assignments.
Academic Integrity: It is essential for students to maintain academic integrity and follow their institution's policies
regarding plagiarism, citation, and referencing. These study notes should be used as learning tools and sources of
inspiration. Any direct reproduction of the content without proper citation and acknowledgment may be considered
academic misconduct.
Limited Liability: The seller shall not be liable for any direct or indirect damages, losses, or consequences arising from
the use of these notes. This includes, but is not limited to, poor academic performance, penalties, or any other negative
consequences resulting from the application or misuse of the information provided.
,UNIVERSITY EXAMINATIONS
OCTOBER/NOVEMBER 2025
INF2603
Databases 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms A Mukhithi
This paper consists of 6 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
cset.myexams.unisa.ac.za.
GOOD LUCK.
, 2
INF2603
OCTOBER /NOVEMBER 2025
QUESTION 1 [18 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.If CUSTOMER and INVOICE is classified as a 1:M and one direction would specify
that a CUSTOMER may generate many INVOICEs, what would be true of the
opposite direction?
a. CUSTOMER is unique to many INVOICEs
b. Each INVOICE is generated by one CUSTOMER
c. Each INVOICE is written to many CUSTOMERs
d. CUSTOMERs are given INVOICEs
2.Use the SQL statement ____ when trying to reference two tables for which data
columns must be updated to reflect the current list of a MASTERINVENTORY, for
example.
a. WHERE MASTERINVENTORY.PROD_ID = PRODSALES.PROD_ID
b. SET MASTERINVENTORY.PROD_ID = PRODSALES.PROD_ID
c. UPDATE MASTERINVENTORY.PROD_ID = PRODSALES.PROD_ID
d. JOIN MASTERINVENTORY.PROD_ID = PRODSALES.PROD_ID
3. What type of dependency is shown during normalization, if the conversion to the
second normal form involves removing all attributes dependent on only a part of a
composite primary key?
a. functional dependency
b. transitive dependency
c. partial dependency
d. primary key dependency
4. A subtype contains attributes that are common to all of its supertypes.
a. True
b. False
TURN OVER
, 3
INF2603
OCTOBER /NOVEMBER 2025
5. To eliminate repeating groups and convert a table into the first normal form (1NF),
what can you change in a table to convert multivalued attributes into single-valued
attributes?
a. primary key
b. dependency
c. business rules
d. focus
6. You are designing a conceptual model and are in the process of matching the
DBMS requirements to the entity-relationship diagram (ERD) to create a data model
that is software-independent. Which stage of the design phase are you doing?
a. internal schema
b. logical design
c. external model
d. physical independence
7. The main goal of normalization is to eliminate _________.
a. dependencies
b. data anomalies
c. repeating group
d. nonkey attributes
8. What do you add to the supertype table for a disjoint condition?
a. disjoint discriminator
b. supertype discriminator
c. subtype discriminator
d. joint discriminator
9. Rows can be grouped into smaller collections quickly and easily using the
COUNT clause within the SELECT statement.
a. True
b. False
TURN OVER
