PetCare Veterinary Clinic
We are a group of three doctors with over 30 years of experience in the veterinary industry.
The clinic is currently located in Presint 2, Putrajaya. At PetCare Veterinary Clinic it is our
commitment to provide quality veterinary care throughout the life of your pet. Our services
and facilities are designed to assist in routine preventive care for healthy pets, early detection
and treatment of disease as your pet ages, and complete medical and surgical care as
necessary during his or her lifetime.
The clinic consists of three doctors each with a very broad experience with treating animals,
two assistants, three cleaners, and an accountant to manage the clinics financial records.
Mission Statement
The purpose of the PetCare Veterinary Clinic database is to provide a well-designed system
for the doctors to view their patients records and other necessary information, pet owners to
view their pets record, and to facilitate the exchange of information between other branches.
Mission objectives
The database will serve as a more organized means of keeping track of the
appointments.
The database will serve as a more organized means of keeping track of the owners
pets previous visits to the clinic.
The database will maintain and store the pets vaccination records.
The database will store the pets surgical records.
The database will store the pets prescription records.
The database will store the pets doctor (for future reference).
The database will maintain and store the pets profile.
The database will maintain and store the owners profile.
The database will store the amount paid and the amount outstanding for each owner.
The pet owners will have access to view the appointment times and pet profile.
The database will store every sale the clinic makes.
The database will store doctors work records.
System Scope and Boundary
The scope of the database covers appointment scheduling, pet health data, doctors
information, owners information, and pet vaccination records.
Collecting & storing appointment dates.
Collecting & storing owners pets previous visits to the clinic.
Collecting & storing the pets vaccination records.
Storing the pets surgical records.
Storing the pets prescription records.
Storing the pets doctor (for future reference).
Collecting and storing the pets profile.
Collecting and storing the owners profile.
Storing the amount paid and the amount outstanding for each owner.
Providing copies of vital records to the pets owners
Responding and tracking customers requests
Creating statistical files
User Access & System Administration Maintenance (ex: tables)
Workload management
Notification and messages to the pets owners
Payroll system is a different and separate system outside the system boundary and it is not
within the scope covered by the database. Also when the customer uses a credit card to make
the payment, the credit card system is also a separate system.
Table 1 Users of the database system
User
Doctor
Information the user can see
All appointment times, pets previous
visit,doctor profile, customer profile, pet
profile, surgical records, medicine
prescribed, vaccination records, and other
Assistant
Accountant
doctors work records.
Pet profile, assistant profile
Financial information such as sales,
Customer
amount outstanding.
Customer appointment time, customer
profile, pet profile.
The table above shows the users of the database system. There are four main users
each with a specific view. The doctor can see more information than any other user of
the system. From the table we can see that doctor, assistant and customer have
overlapping requirements and accountant has distinct requirements.
Data to be used:
doctors full name
doctor address
doctors salary
doctors gander
doctors position
doctors phone
customers name
customers address
customers telephone
name of the vaccine
price of the vaccine
quantity of the vaccine
pet name
pet species
prescription name
prescription price
prescription code
Entities, Relationship and Attributes
Table 2 Entities, relationships and attributes of the database system.
Entity
Relationship
Entity
Doctor
Customer
Doctor_ID
Customer_ID
First_name
First_name
Last_name
Has
Last_name
TelNo
TelNo
Salary
Home_Add
Gender
BirthDate
BirthDate
Gender
Customer
Appointment
Customer_ID
Appointment_Date
First_name
Appointment_Time
Last_name
TelNo
Makes
Home_Add
BirthDate
Gender
Pet
Vaccination
Name
Vaccine_Date
Customer_ID
Receives
Age
Doctor_ID
Vaccine_Status
Breed
Customer
Pet
Customer_ID
Name
First_name
Owner
Last_name
Owns
Age
TelNo
Breed
Home_Add
Weight
BirthDate
Gender
Doctor
Medicine
Doctor_ID
Dosage
First_name
Doctor
Last_name
Prescribes
Expiration_date
TelNo
Production_Date
Salary
Type
Gender
Name
BirthDate
