Database Answers Header Dental Center in Morley, Western Australia (Click for Web Site)
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Patient Visits to the Doctor
  Back to the Data Model.
The Requirements have been defined as follows by Claudette Harrington :-
Well I'm stuck again. 

I have searched your site for this information and I found several health care designs but 
none of them had all the tables I needed , so again I am humbly asking for your help. 

I need an example of a star schema data warehouse that helps me answer questions like these :-
"What fraction of patients tends to go to doctors in their hometown ?"
"What are the top 10 diseases by cost of treatment ?"
"What are the most effective treatments for each disease ?"
"What are the treatments with the highest /lowest side effects ?" 

The analysis should take the age of the patients into account.

  • Barry says the Business Rules are :-
  • Patients make Visits to Doctors located in Medical Centers.
  • Patients and Medical Centers have Addresses that are stored in an 'Addresses' Table for easy validation.
  • Medical Procedures such as X-Rays are carried out on Patients.
  • Each Procedure has a Cost and the total Cost of Procedures for each Visit is Derived and stored.
  • During a Visit, the Doctor might prescribe Medication for the Patient.
  • Each Medication has a Cost and the total Cost is derived and stored.
  • © DatabaseAnswers.org 2010
    About Us Contact Us