VET Clinic Information System In this project, you are assigned to design, organize and implement a RDBMS for Veterinary

[answerhappygod]

VET Clinic Information System In this project, you are assigned
to design, organize and implement a RDBMS for Veterinary Clinic
that will store, manipulate and retrieve all related information.
The database you will design will organize the information about
all the pets, vets, inspections, treatments etc. as well as: ➢ The
DB should store detailed information about the pets which get
inspected regularly in the clinic including pet’s id, name,
date_of_birth, genre, type etc. ❖ Exotic pets include birds,
reptiles, and other non-mammals, and the Vet Clinic would like to
keep track of any special foods, habitat, and care required for
exotic pets. For domestic pets, the Clinic stores license numbers.
➢ The Customers’ (who are the owners of one or more pets) details
should also be stored in the database. They should also be able to
take an appointment to get their pet inspected. ➢ Each pet get
inspected by only one vet but a vet can inspect many pets. Other
than inspections, vets can also apply medical treatments or
operations in the clinic. ➢ There are many vets and several other
staff who serve as receptionists and assistants (when there is a
need for an operation assistants help vets). ➢ In addition to
providing veterinary services, the clinic also sells a limited
range of pet supplies. Therefore, there is a need to store the
details of pet supplies as well as sales records (which customer
(pet owner) buy which pet supply). The cardinalities must also be
mapped out after establishing the relationships that exist such as
a customer owns one or more pets, purchases a pet supply etc. by
doing this you also need to outline your weak entities wherever
necessary. At the end of this project, you will submit a report
that contains the following items: with diagram
in Database Management system 1