GreenTree Vet Clinic provides veterinary services to the local community. A
database driven website will record information about clients, their pets,
health care provided to the animals, vaccines provided to the animals, and
general appointment information. GreenTree Vet Clinic is a small neighborhood
clinic that has a maximum capacity of 3,000 pets. The database will have the
capability to support multiple animals per owner. Therefore, the client count
should be less than the amount of pets serviced. The veterinary is looking to
be more eco-friendly and transition from a paper record model to an electronic
database model. The implementation of the electronic database will equate to
less time rummaging through file cabinets and more time spent taking care of
animals, which is critical in a low staff atmosphere.
GreenTree Vet Clinic would like to store vaccine and appointment
information on all of the pets that receive care from them. Services provided
by the veterinary will be performed during appointments. In addition to
general care, all vaccines administered by GreenTree will also be done through
an appointment at their facility.
| Table Name | Description |
|---|---|
| Owners | An entity that contains data about our customers. |
| Pets | An entity that contains data about our customer’s pets. |
| Species | An entity to apply species information to a pet. |
| Appointments | An entity that contains information about a pet’s appointment such as the reason for the appointment and the summary of the appointment - which will include vaccines that were administered. |
| Vaccines | An entity that contains information about available vaccines. |
| Appointments_Vaccines | An intersection table that supports the M:N relationship between Appointments and Vaccines. |
© 2022 James Cole, Patrycjusz Bachleda
This section was added after the project was submitted for final grading.
