Political Science homework help
This office houses four vets, one who specializes in large animals and the others in small animals. The veterinarians want to set up a database to track patients (animals), owners, and the associated veterinarian.Business rules:Veterinarians treat numerous patientsEach patient has a primary-care veterinarian assignedA single owner is associated with each patientOwners may have numerous patients (pets)Each vet has only one specialtyOwner data is kept to provide contact information and to facilitate payment of billsYour goal: Use Gliffy to draw a practical ERD to keep track of data requested by the veterinarians. Include primary keys, foreign keys, and requested attributes to store data pertaining to the described scenario within a relational data model. Paste your ERD in the space below.