Category: Uncategorized

What is the result of executing the following relational tuple calculus query? 

What is the best mapping into relations for the following EER diagram?  

What DID values are retured by the following query? SELECT DIDFROM DriverWHERE phone LIKE ‘_0%’;

For all states of this database, which of the following SQL queries is/are equivalent to this relational tuple calculus query?

Which query returns the RID of all Riders who have never taken a ride?

Which values are returned from the following nested SQL query? SELECT Dname FROM Driver WHERE DID IN (SELECT DID FROM RideDetail WHERE RID IN (SELECT RID FROM Rider WHERE MemberSince > 2017-01));

Considering the provided database, after executing the following update statement: UPDATE RideDetail xSET tip = price * 0.1WHERE price > 15; What RID value(s) would be returned by the following query: SELECT RIDFROM Rider rWHERE NOT EXISTS (SELECT * FROM RideDetail x WHERE x.RID = r.RID AND TIP > 4);

Which of the following relational algebra queries returns a single tuple with a value of 25?

Hypothetically, if a constraint were added that a rider can have only one ride per day, how many candidate keys are there for the RideDetail relation?Please note this hypothetical situation applies to only this question.

For a relation  which contains two candidate keys  and :