Question: Write a relational algebra expression that returns the manufacturer name whose cars won the greatest number of races. Write a relational algebra expression manufacturer for

Write a relational algebra expression that returns the manufacturer name whose cars won the greatest number of races.
Write a relational algebra expression manufacturer for cars with low horsepower, meaning that all its manufactured cars are less than 800 horsepower.
Racer A ID Name 1 Sam 2 Suzan 13 Alice Gender Birth_year M 1984 F 1982 F 1980 Car CID Manufacturer Horse_power Nbr of cylinder C1 Mercedes 1200 6 C2 Ferrari 2400 8 C3 Mercedes 800 4 Result Result IDC_ID R_ID A_ID Time R1_1 C1 R1 1 400 R1_2 C2 R1 2 600 R1_3 C3 3 375 Race RID Type Location R1 F1 UK R2 RallyCross Portugal R3 F1 Sponsor RID R1 R1 R2 CID Sponsor C1 Motorola C3 Pepsi C4 Michelin R1 USA Schema: Racer: (A_ID, Name, Gender, Birth_year) Race (R_ID, Type, Location) Result (Result_ID, 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 for Race. Sponsor (R_ID, C_ID, Sponsor) Car (C_ID, Make, Horsepower)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
