State ONE function of referential integrity.
About this question
Question 4.5.2 of Information Technology Grade 12 Paper 2, NSC Preparatory Examination (Eastern Cape DoE, September 2025). It tests the Term 1 ATP topic Database Design & Concepts Design.
- TermTerm 1
- ATP topicDatabase Design & Concepts Design
- PaperPaper 2
- Marks1 mark
A catering equipment company has a poorly designed database with TWO tables, shown below.
tblClient
tblStock
It makes sure that no record in the child table can exist without a matching record in the parent table.
More Questions On Database Design & Concepts Design
Format check: it makes sure the date is entered in the required pattern, for example YYYY/MM/DD.
Two anomalies that can occur in tblClient are:
- Insert anomaly: a company's details cannot be added unless it places an order.
- Delete anomaly: deleting an order can wipe out the only record of the company's details.
Profit. It can be calculated from the other fields (SellingPrice minus CostPrice), so storing it duplicates data.
An anomaly is an error that occurs when data is inserted, deleted or updated in a table.
Normalisation is the series of steps followed in designing a database so that redundancy and anomalies are prevented.
A relational database has multiple tables that are linked through relationships using primary and foreign keys.