Examine the dimensional model (star schema) shown in Figure 2. This model describes part of a database that will provide decision support for a taxi company called FastCabs. This company provides a taxi service to clients who can book a taxi either by phone a local office or online through the company's Web site. The owner of FastCabs wishes to analyze last year's taxi jobs to gain a better understanding of how to resource the company in the coming years. Staff Office staffNo office (PK) homeAddress job Description street salary manager Name staff DPK) fullName officeNo NIN Sex city postcode dob Client clientID (PK) clientNo fullName street city postcode Job jobID {PK) officeID (FK) driver Staffi {FK) clientID {FK) vebRegid (FK) pickUpDate {FK) pickup Time FK) pickupPcode (FK) drop OfPcode FK noJobReason (FK) mileage charge Taxi vebRegiD (PK) vebReg No model make color Capacity Date Time time (PK) 24hourclock ampm indicator day Segment shirt date (PK) day OlWeek week month quarter season Year Reason noJobReasonID (PK) reasonDescription Location locationID {PK) postcode area town city region Figure 2 Describe the changes that would be necessary to the star schema shown in Figure 2 to support the following analysis and also discuss the exact position where those changes will be applied as per Figure 2 a. Analysis of taxi jobs to determine whether there is an association between the reasons why taxi jobs are cancelled and the age of clients at the time of booking. b. Analysis of taxijobs according to the time drivers have worked for the company and the total number and total charge for taxi jobs over a given period of time. C. Analysis of taxi jobs to determine whether there are more or less jobs at different weeks of the year and the effect of public holidays on bookings. Examine the dimensional model (star schema) shown in Figure 2. This model describes part of a database that will provide decision support for a taxi company called FastCabs. This company provides a taxi service to clients who can book a taxi either by phone a local office or online through the company's Web site. The owner of FastCabs wishes to analyze last year's taxi jobs to gain a better understanding of how to resource the company in the coming years. Staff Office staffNo office (PK) homeAddress job Description street salary manager Name staff DPK) fullName officeNo NIN Sex city postcode dob Client clientID (PK) clientNo fullName street city postcode Job jobID {PK) officeID (FK) driver Staffi {FK) clientID {FK) vebRegid (FK) pickUpDate {FK) pickup Time FK) pickupPcode (FK) drop OfPcode FK noJobReason (FK) mileage charge Taxi vebRegiD (PK) vebReg No model make color Capacity Date Time time (PK) 24hourclock ampm indicator day Segment shirt date (PK) day OlWeek week month quarter season Year Reason noJobReasonID (PK) reasonDescription Location locationID {PK) postcode area town city region Figure 2 Describe the changes that would be necessary to the star schema shown in Figure 2 to support the following analysis and also discuss the exact position where those changes will be applied as per Figure 2 a. Analysis of taxi jobs to determine whether there is an association between the reasons why taxi jobs are cancelled and the age of clients at the time of booking. b. Analysis of taxijobs according to the time drivers have worked for the company and the total number and total charge for taxi jobs over a given period of time. C. Analysis of taxi jobs to determine whether there are more or less jobs at different weeks of the year and the effect of public holidays on bookings