|
Back to the Data Model
The Area being Modelled is :-
Medical clinics and Pharmacies in my country
Question: I want to design a program to count medical clinics and pharmacies in my
country and be search by state or city or region,
what is the form of relations between the tables required
Note that the tables that are designed
1. statetab stateid satename
2.citytab cityid cityname
3.ariatab ariaid arianame
4. MedicalClinicTab ClinicID ClinicName ClinicType ClinicManagerName
B. Barry says the Things of Interest are :-
1. Clinics
2. Drugs
3. Medication
4. Prescriptions
5. Others to be determined
C. The Business Rules are as follows :-
1. To be determined.
© DataBase Answers Ltd. 2011
|
|