Question 2 (8 marks) Read and analyse a specification of data warehouse domain listed below. A Formula One fan club wants to set up a database to keep track of the results of all drivers in all races in all the seasons since the first Formula One World championship in 1950. For each driver, the following information should be kept: name, nationality, birth date and birth place, Drivers are hired by teams competing in a season as either main drivers or test drivers. A team is allowed to have at most two main drivers per single race. A season is held on a year, between a starting date and an ending date, has a number of race events, and is described by a summary and a set of regulations. A driver participating in a race must pass through a qualifying session, which determines the starting order for the race. The results kept for a driver participating in a race are the following: position (may be optional), number of laps, time, the reason why the driver retired or was disqualified (both may be optional), and the number of points (scored only for the top eight finishers). The Formula One races are organized in different countries, in different cities and on different race circuits. The fan club would like to organize a data warehouse such that following information can be retrieved/computed later on. (1) Find the total number of seasons in Formula One races per driver and per team. (2) Find the total number of races entered per driver, per team, per year and per month. (3) Find the total number of races won per driver, per team in a given year, per race circuit. (4) Find the total number of podiums reached per driver, per team in a given year, per race circuit. (5) Find the total points in the career per driver and per team. (6) Find an average number of grid positions per driver and per team. (7) Find an average time of fastest laps per driver and per race circuit. (8) Find the highest race finish (consisting of place and number of times). (9) Find the highest grid position (consisting of place and number of times). (10) Find an average race speed per driver, per race circuit, per race event. Your task is to create a conceptual schema of a sample data warehouse domain listed above. To draw a conceptual schema, use a graphical notation explained to you during the lecture classes in a subject ISIT312