DATABASE CONCEPTS

Part A

i$.$ Using the entity$-$relationship diagram template below, fill in the blanks $(\text{'}$a$\text{'}$ to $\text{'}$d$\text{'})$ indicated in the template to model the relationships between employee and company car as zero to one $(0$:$1).$

$(4$ marks$)$

ii$.$ Discuss and provide relationship sentences for the model.

Part B

Transform the following table into the third normal form. Show your results for each normal form, including $0$ normal form.