Question X. (4 points) Write a relational algebra expression for the cars that finished the race in a time smaller than all races average time, Instructions When writing a query, write the query in a way that it would work over all possible database instances and not just for the given example instance! Consider the following database schema and example instance for a race car database: Good luck Car Racer A ID Name 1 Sam 2 Suzan 3 Alice Gender Birth year M 1984 F 1982 F 1980 CID Manufacturer Horsepower Nbr of cylinder C1 Mercedes 1200 6 C2 2400 8 8 C3 800 4 Question XI- (3 points) Write a relational algebra name that participated in each race. Ferrar Mercedes Result Race Result DC ID RIDA_ID Time R1_1 C1 R1 1 400 R1_2 C2 RI2 500 R1_3 C3 R1 3 375 RID Type Location R1 F1 UK RZ Ballycross Portugal R3 F1 USA Sponsor R_ID R1 R1 RZ CD Sponsor C1 Motorola C3 Pepsi C4 Michelin Schema Question XII 15 points) Write a relational algebra expression that returns the manufacturer name whose cars won the greatest number of races. Racer: (A_ID, Name, Gender, Birth read Race (R_ID, Type, Location Result (Result_D.C_ID, A_ID, R_ID, Time) C_ID is a foreign key for car and A_ID is foreign key for Racer and R_ID is a foreign key fer Race Question XIII. (4 points) Write a relational algebra expression manufacturer far cars with law horsepower, meaning that all its manufactured cars are less than 300 horsepower. Sponsor (R_ID, C_ID, Sponsor) Car (C_ID, Make, Horsepower Question X. (4 points) Write a relational algebra expression for the cars that finished the race in a time smaller than all races average time, Instructions When writing a query, write the query in a way that it would work over all possible database instances and not just for the given example instance! Consider the following database schema and example instance for a race car database: Good luck Car Racer A ID Name 1 Sam 2 Suzan 3 Alice Gender Birth year M 1984 F 1982 F 1980 CID Manufacturer Horsepower Nbr of cylinder C1 Mercedes 1200 6 C2 2400 8 8 C3 800 4 Question XI- (3 points) Write a relational algebra name that participated in each race. Ferrar Mercedes Result Race Result DC ID RIDA_ID Time R1_1 C1 R1 1 400 R1_2 C2 RI2 500 R1_3 C3 R1 3 375 RID Type Location R1 F1 UK RZ Ballycross Portugal R3 F1 USA Sponsor R_ID R1 R1 RZ CD Sponsor C1 Motorola C3 Pepsi C4 Michelin Schema Question XII 15 points) Write a relational algebra expression that returns the manufacturer name whose cars won the greatest number of races. Racer: (A_ID, Name, Gender, Birth read Race (R_ID, Type, Location Result (Result_D.C_ID, A_ID, R_ID, Time) C_ID is a foreign key for car and A_ID is foreign key for Racer and R_ID is a foreign key fer Race Question XIII. (4 points) Write a relational algebra expression manufacturer far cars with law horsepower, meaning that all its manufactured cars are less than 300 horsepower. Sponsor (R_ID, C_ID, Sponsor) Car (C_ID, Make, Horsepower
