[Solved]Create Fully Normalised Erd Following Scenario Halbeath Veterinary Surgery Keeps Record Vi Q37287004

Create a fully normalised ERD for the following scenario.

Halbeath Veterinary Surgery keeps a record of visits fromvarious pets. They would like a database to keep the information,which is currently kept on card files.

The owner card is completed and the pet owner given aregistration number. A pet register card is filled in for each oftheir pets.

Visits and details of treatments are recorded on a separate setof cards and, at the end of each quarter, an invoice is sent outsummarising the treatment given.

Within this system an owner only has one address. All pets atthat address, for billing purposes, have the same owner.Consequently, each pet can only have one owner.

Furthermore, it is possible for a pet to visit the surgery twiceon the same day. A different vet for each of those visits canattend, but only one vet is in attendance during a visit.

Expert Answer

---

Answer to Create a fully normalised ERD for the following scenario. Halbeath Veterinary Surgery keeps a record of visits from vari… . . .