here is an example you can look at: http://academic2.strose.edu/math_and_science

Question

here is an example you can look at: http://academic2.strose.edu/math_and_science/avitabij/csc503fall13/exams/fall2012exam1answers.pdf

Part 1 Use the following database to answer all questions in Part 1. You will write a relational algebra expression for each question. CLIENT ClientID, ClientName, ClientPhone, ClientEmail, ClientDOB, ClientReferenceID) DRIVER Driver ID, DriverName, Driver Phone. Driver Eimai DriverCity, DriverDOB) RIDE DriverID, ClientID, RideDate, RideTime, StartAddress, EndAddress, Fee, Tip) RATING Driver ID, ClientID, RatingValue) The Client ReferenceID matches a ClientID of another climber. A. Write a query to output the name and birthdate of all drivers who live in Albany B. rite a query to output the average Rating 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.

Explanation / Answer

select DriverName, DriverDOB from DRIVER where DriverCity = 'Albany'

select avg(RatingValue) from RATING

select concat(DriverName, ClientName) , concat(DriverEmail,ClienEmail) from DRIVER, CLIENT

select DriverID from driver where DriverID = ( select DriverID from RIDE where ClientID=''

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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