Star schema for a data warehouse

[remo]

A health centre is characterised by the following processes:
 Patients go to doctors. Patients have a home address (city, country).
Likewise doctors have a work address. Patients have either a private or
public insurance. Furthermore, patients have an age.
 Doctors keep records for all their patients. These records keep information
of the disease that a patient has and the data and type of treatment.
Furthermore, the patient record keeps information on whether each
application of the treatment is effective (score from 1 to 6; 6 is good) and
whether there were any side effects (score from 1 to 6; 6 = no side
effects).
 A treatment can either be a certain medication (e.g. Aspirin, Placebo,…)
or surgery (e.g. heart surgery, arthroscopy,…). Each treatment has a cost
for private patients and for public patients. For example, heart surgery
costs £50000 for private patients and £20000 for public patients.


question is...
State which tables are fact tables; which tables are dimension tables?
What are the measures of the fact tables?

[remo]

Main confused is, \ is possible to come more than one face table in star schema?

[hkandpal]

Hi,

a star schama is one fact table, surrounded by multiple dimension tables. You can have scenarios where a dimension will be shared by more than one fact table eg. like Time dimension, Country dimension ...


thanks

[Sponsored content]