Back to the Data Model
Requirement is a Database for a Vets Practice.
The Statement of Requirements from the Users is as follows :-
The Database should contain a customer table, treatments table ,
species,(type of dog, cat, bird, etc...), pet table with color, birthdates,
height, weight, medications table with dosage, cost, date and comments.
B. The Things of Interest are :-
B.1 Animals
B.2 Customer Table
B.3 Medication
B.4 Species
B.5 Species Type,(type of dog, cat, bird, etc.)
B.6 Treatment Table
B.7 Vets
C. How are they related ?
C.1 An Animal can be seen by many Vets.
C.2 A Vet can see many animals.
Barry Williams
12th. November 2004
Principal Consultant
Database Answers