Star schema for a data warehouse

View previous topic View next topic Go down

Star schema for a data warehouse

Post  remo on Fri Sep 21, 2012 5:16 pm

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

Posts : 2
Join date : 2012-09-21

View user profile

Back to top Go down

Re: Star schema for a data warehouse

Post  remo on Fri Sep 21, 2012 5:32 pm

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

remo

Posts : 2
Join date : 2012-09-21

View user profile

Back to top Go down

Re: Star schema for a data warehouse

Post  hkandpal on Mon Sep 24, 2012 2:44 pm

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


hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Star schema for a data warehouse

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum