named Steve Mike Use the following database to answer all questions in Part 1. Y
ID: 644684 • Letter: N
Question
named Steve Mike
Use the following database to answer all questions in Part 1. You will write a relational algebra expression for each question. CLIENT(ClientlD, ClientName, ClientPhone, ClientEmail, ClientDOB, ClientRefercnceID) DRIVER(DriverlD, DriverName, DriverPhone, DriverEmail, DriverCity, DriverDOB) RIDE(RidelD, DriverID, ClientlD, RideDate, RideTime, StartAddress, EndAddress, Fee, Tip) RATING(DriverlD, ClientlD RatingValue) The ClientReferencelD matches a ClientlD of another climber .A. Write a query to output the name and birthdatc of all drivers who live in Albany. B. Write a query to output the average RatingValue in the RATING table. C. Write a query to output the name and email of all clients and drivers. There should be just two columns in this output. D. Write a query to output the DriverID of all drivers who have never given a ride. E. Write a query to output the drivername, driverphone, ridedate, ridetime, startaddress, and endaddress for all drivers and their rides. If the driver has never given a ride, we should still see that driver's name and phone in the output. F. Write a query to output the name of all clients and the name of their reference. G. Write a query to output the name of all drivers and their average Rating Value. H. Write a query to output the name of all clients who have taken a ride with every driver. I. Write a query to output the names of all clients who have taken a ride with the driver. named Steve MikeExplanation / Answer
Answer:
A. CLIENT(<u>ClientID</u>, ClientName, ClientPhone, ClientEmail, ClientDOB, ClientReferenceID)
B. RATING(<u>DriverID</u>, <u>ClientID</u>, RatingValue)
C. ?ClientName,ClientEmail (CLIENT) U ?DriverName,Driver (DRIVER)
D. DRIVER(<u>DriverID</u>, DriverName, DriverPhone, DriverEmail, DriverCity, DriverDOB)
E. DRIVER(<u>DriverID</u>, DriverName, DriverPhone, DriverEmail, DriverCity, DriverDOB)
F. CLIENT(<u>ClientID</u>, ClientName, ClientPhone, ClientEmail, ClientDOB, ClientReferenceID)
G. RATING(<u>DriverID</u>, <u>ClientID</u>, RatingValue)
H. RIDE(<u>RideID</u>, DriverID, ClientID, RideDate, RideTime, StartAddress, EndAddress, Fee, Tip)
I. RIDE(<u>RideID</u>, DriverID, ClientID, RideDate, RideTime, StartAddress, EndAddress, Fee, Tip)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.