-
Database: Relational Algebra
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|