Star Schema for University Hospital

Description of Data Dictionary

Dimensional Table -Doctor

1)Doct_Id - A Unique for the doctors identification

2)Doct_Name - information about doctors name

3)Doct_Age - details about doctors agei

4)Doct_Unit - records about which operation unit does the doctor assigned

Dimensional Table - Patient

1)Pat_Code - A unique identification code is assigned to patient

2)Pat_Name - Details about the patients name

3)Pat_Age - Records about the patients age

4)Pat_Add - Details about the patient house add or staying address

Dimensional Table - Time

1)Hour,Month and Year - Details about the attendance of patient

Fact Table - Sales

1)Pat_Code - Unique id of patient

2)Doct_id - Unique if of doctor

3)Time_id - Attendance of patient