INF2603 EXAM PACK 2026

INF2603
EXAM PACK




FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739

,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