t$.(8)$

Question $5($Marks: $10)$

Differentiate between a one$-$to$-$many and one$-$to$-$one relationship. Provide an example of each in

the context of a grocery store.

$21$; $22$; $232023$

$$ The Independent Institute of Education $($Pty$)$ Ltd $2023$ Page $8$ of $8$

Question $6($Marks: $10)$

Data that is relational in nature is best described by means of a relational data model.

Q$\mathrm{.}6\mathrm{.}1$ Define redundant data and provide an example in the context of a bank. $(4)$

Q$\mathrm{.}6\mathrm{.}2$ The below Entity Relationship Diagram $($ERD$)$ was drawn according to the

business rules shown below.

Book club business rules:

$$ A book belongs to a genre, and many books can belong to the same

genre.

$$ A member chooses one favourite genre, and a genre can be chosen as

the favourite of many members.

$$ A member reads many books, and each book can be read by many

members.

Explain any three changes that should be made to the ERD to accurately

reflect the business rules. Provide a full description of the change and the

reason for the change.