Using these tables: Car(VIN, Make, Model, Year) Location(LocationID, City, State

ID: 3804928 • Letter: U

Question

Using these tables:

Car(VIN, Make, Model, Year)

Location(LocationID, City, State, Zipcode, Airport)

Customer(CustomerID, Name, Address, email)

Rental(RentalID, VIN, LocationID, CustomerID, PickupDate, DropoffDate)

Express the following as relational algebra queries:

a. The name and email of all customers.

b. The make, model, year, pickup date, and dropoff date of all cars rented by customer C293048.

c. The VINs for all 2007 Honda Civics.

d. The number of locations in Massachusetts.

e. The number of locations in each state.

f. The list of all customers who have rented every Honda model.

a)select name,email from Customer;

b)select VIN from Car where Year=’2007’ and Model=’ Civics’ and Make=’ Honda’;

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.