$($a$)$ Appendix A is a table of data from a veterinarian practice.

Required:

i$.$ Copy and complete the following table.$(3$ marks$)$

Entity # $1$

Nature of the

Association verb

Entity # $2$

Cardinality

Owner

$$

Patient

$$

Patient

$$

Animal Description

$$

Patient

$$

Service

$$

$$

$$

$$

$$

ii$.$ Data normalization is the process of systematically reducing a complex table to a set of simple efficient tables that meet two conditions

I $.$ All non$-$key attributes in the table are dependent on the primary key.

$2.$ All non$-$key attributes are independent of the other non$-$key attributes.

Using the information from part i normalize the table labelled Appendix A to $3$NF$,$ clearly identifying the primary key $($PK$)$ in each table.

$($Show ONLY the field names of the tables.$)$