Question

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 1984 1982 F Manufacturer Hourse_power Mercedes 1000 Ferrari 5000 Mercedes 700 C2 1980 Sponsor R_id C_ID Result result_id c_id r_id A_id Time R1_1 C1 R11 400 R1_2 c2 R1 2 600 R1_ 3c3R13 375 Race R_id Type Location R1 R2 RallyCross Portugal R3F1 USA UK R1 ci Sponsor Motorola Pepsi Michelin R1 C3 R2 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)

Answer 1

******************************************************************************************
Please Upvote the answer as it matters to me a lot :)
*****************************************************************************************
As HOMEWORKLIB RULES expert answering guidelines,Experts are supposed to answer only certain number of questions/sub-parts in a post.Please raise the remaining as a new question as HOMEWORKLIB RULES guidelines.
******************************************************************************************

select sponsor.sponsor, result.r_id, racer.name
from sponsor , result, racer
where sponsor.r_id= result.r_id and result.A_id= Racer.A_id