Database: Relational Algebra

[chetah]

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

[Figo]

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

[chetah]

Thank you very much. Solved the problem