Tutorial 1: Soo Hsaio Pei WGA 060050

Name : Soo Hsaio Pei
Matric No: WGA 060050
Date : 05/01/2007

Question:
Suppose that a data warehouse, University Hospital, consists of the three dimensions time, doctor and patient and two measures: charge and count. Draw a schema diagram for the above data warehouse using Star schema.

Answer:


Dimensions:
i. Patient - There are details such as health description, admitted and discharge dates, patient's
personal details and identity number indicating all information and conditions of
the patient.
ii.Doctor - Number of patients being supervised by each doctor is recorded so that estimation of
of sufficient doctors can be done.
ii. Time - There are different calculations of the timing such as how many hours that an
operation needs,how many patients admitted into hospital in a week and so forth.