A French horse race fan wants to set up a database to analyze the performance of the horses as well as the betting payoffs. A racetrack is described by a name (e.g., Hippodrome de Chantilly), a location (e.g., Chantilly, Oise, France), an owner, a manager, a date opened, and a description. A racetrack hosts a series of horse races. A horse race has a name (e.g., Prix Jean Prat), a category (i.e., Group 1, 2, or 3), a race type (e.g., thoroughbred flat racing), a distance (in meters), a track type (e.g., turf right-handed), qualification conditions (e.g., 3-year-old excluding geldings), and the first year it took place. A meeting is held on a certain date and a racetrack and is composed of one or several races. For a meeting, the following information is kept: weather (e.g., sunny, stormy), temperature, wind speed (in km per hour), and wind direction (N, S, E, W, NE, etc.). Each race of a meeting is given a number and a departure time and has a number of horses participating in it. The application must keep track of the purse distribution, that is, how the amount of prize money is distributed among the top places (e.g., first place: e228,000; second place: e88,000, etc.), and the time of the fastest horse. 2.9 Exercises 49 Each race at a date offers several betting types (e.g., tierc e, quart e+), each type offering zero or more betting options (e.g., in order, in any order, and bonus for the quart e+). The payoffs are given for a betting type and a base amount (e.g., quart e+ for e2) and specify for each option the win amount and the number of winners. A horse has a name, a breed (e.g., thoroughbred), a sex, a foaling date (i.e., birth date), a gelding date (i.e., castration date for male horses, if any), a death date (if any), a sire (i.e., father), a dam (i.e., mother), a coat color (e.g., bay, chestnut, white), an owner, a breeder, and a trainer. A horse that participates in a race with a jockey is assigned a number and carries a weight according to the conditions attached to the race or to equalize the difference in ability between the runners. Finally, the arrival place and the margin of victory of the horses are kept by the application. 1.Design a MultiDim schema for the French horse race application given in above. With respect to the races, the application must be able to display different statistics about the prizes won by owners, by trainers, by jockeys, by breeders, by horses, by sires (i.e., fathers), and by damsires (i.e., maternal grandfathers). With respect to the bettings, the application must be able to display different statistics about the payoffs by type, by race, by racetrack, and by horses.