Decompose the following query into Relational Algebra expression:
Select VehicleId, CustomerName
From Rental, Customer
Where Rental.CustomerId = Customer.CustomerId
And DateOut = ’24-SEP-08’
And DateReturn IS NULL
Help needed
Printable View
Decompose the following query into Relational Algebra expression:
Select VehicleId, CustomerName
From Rental, Customer
Where Rental.CustomerId = Customer.CustomerId
And DateOut = ’24-SEP-08’
And DateReturn IS NULL
Help needed
Hi Here's what it should be in relational algebra:
Please note that, you have to substitute the bold operations with the relevant symbols as I can't write them here.
PROJECTVehicleId, CustomerName (SELECT Rental.CustomerId = Customer.CustomerId and DateOut = ’24-SEP-08’ and DateReturn is NULL (Rental JOIN Customer))
Good Luck
Thank you very much. Solved the problem