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.

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

(b) Suppose that among the attributes of the time dimension day and year are included. What OLAP operation should be performed to aggregate the data by ascending from day to year?