A veterinary clinic manages the medicalcare needed for pets. A pet owner may have several pets (dogs cats rabbitsetc.) with the following restrictions:I. Each pet belongs to aparticular owner.2. Eachpet is fussy and eats only particular types of pet
A veterinary clinic manages the medicalcare needed for pets. A pet owner may have several pets (dogs cats rabbitsetc.) with the following restrictions:I. Each pet belongs to aparticular owner.2. Eachpet is fussy and eats only particular types of pet food.3. Morethan one pet may eat each type of pet food.4. Eachpet may take several medications.The dosage will vary for each pet.Use the information provided above supplemented with your knowledgeofveterinary clinics and pets to create:1)an ERD and 2) a set of third normalform relations to represent the pet clinic database. Use only the following attributes:OwneriDPetFoodName#OfPetsOwnedOwnerNamePetTypeFoodCostPerPoundPetiDPetAgeMediDPetNameOwnerPhone#MedDosageDo not includeforeign keys on the ERD. Underline the primary key of each relation. It may behelpful to create your own sample data. Document any additional assumptions you make