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 table that contains data about our customers. |
| Pets | An entity table that contains data about the Pets that we care for. |
| Species | An entity table that contains species information to assign to various pets. |
| Appointments | An entity table 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 table that contains information about available vaccines that can be administered during appointments. |
| 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.
As a demonstration of the seamless design of Asynchronous JavaScript and XML (AJAX), the Owners, Pets, and Species pages have been designed with full support of AJAX. The Appointments, Vaccines, and Appointments_Vaccines pages have been implemented with minimal AJAX.
