Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Horse_power Nbr of cylinder C1 Mercedes 1200 6 C2 Ferrari 2400 8 Mercedes 800 4 Result Race Sponsor RID R1 Result DC_ID R_ID A_ID Time R1 1 c1 R11 400 R1_2 C2 R1 |2 600 R1 3 C3 3 375 R D Type Location R1 F1 UK R2 RallyCross Portugal R3 F1 USA CID Sponsor C1 Motorola C3 C4 Michelin Pepsi R1 R2 R1 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) Question IV (5 Points) Write a relational algebra expression that returns the female racer's name, born before 1982 with the highest race time. Question V (5 Points) Write a relational algebra expression that returns the racer's name and associated race sponsor that drove a 'Mercedes' car during at least one of their races. Question VI (4 Points) Write a relational algebra expression that return the winner name in each race. The winner is the racer that finishes the race in least time
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started