Database Answers Mass General Hospital

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Medical Clinics and Pharmacies 
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
About Us Contact Us