Question: Question VII (4 Points) Write a relational algebra expression that returns the horsepower per cylinder, assuming that the horsepower is equally proportional to the number

 Question VII (4 Points) Write a relational algebra expression that returns

Question VII (4 Points) Write a relational algebra expression that returns the horsepower per cylinder, assuming that the horsepower is equally proportional to the number of cylinders. 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 Gender Birth year M 1984 F 1982 F 1980 2 Suzan CID Manufacturer Horse_power Nbr of cylinder C1 Mercedes 1200 6 C2 Ferrari 2400 8 Mercedes BOD 4 4 Question VIII (4 points Write a relational algebra that returns the racer's name that only drives Ferrari. E 3 Alice Result Race Question IX-13 points) Write a relational algebra narie that never participated in a 'rallycross' racer. Sponsor R_ID R1 Result DC_IDR_ID A ID Time RI_1 C1 R11 400 HL 2 CZ RI 2 500 R1_3 C3 R1 3 375 RID Type Location R1 F1 UK RZ Rallycross Portugal R3 F1 USA C_ID Sponsor Motorola C3 Pepsi C4 Michelin R1 R2 Schema: Racer: (A_ID, Name, Gender, Birth_yead RaceR_ID, Type, Icxation) Result (Result ID.C_ID, A_ID, R_ID, Timel 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!