$($b$)$ Suppose that a data warehouse consists of the three dimensions time, doctor, and

patient, and the two measures count and charge, where charge is the fee that a doctor

charges a patient for a visit.

$($i$)$ Draw a star schema diagram for the above data warehouse.

$($ii$)$ Starting with the base cuboid $[$day$,$ doctor, patient$],$ what specific OLAP operations

should be performed in order to list the total fee collected by each doctor in $2013?$

$($iii$)$ If each dimension has ten levels $($including all$),$ how many cuboids will this cube

contain $($including the base and apex cuboids$)?$

$[$