(a) A company called Perfect Pets runs a number of clinics. A clinic has many staff and amember of staff manages at most one clinic (not all staff manage clinics). Each clinic has aunique clinic number (clinicNo) and each member of staff has a unique staff number(staffNo).

(b) When a pet owner contacts a clinic, the owner�s pet is registered with the clinic. An ownercan own one or more pets, but a pet can only register with one clinic. Each owner has aunique owner number (ownerNo) and each pet has a unique pet number (petNo).

(c) When the pet comes along to the clinic, it undergoes an examination by a member of theconsulting staff. The examination may result in the pet being prescribed with one or moretreatments. Each examination has a unique examination number (examNo) and each typeof treatment has a unique treatment number (treatNo).

(d) Represent the complete set of requirements in one ER diagram.

(e) Convert the E-R model to Relational tables.