Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 can anybody help with this please

Author  Topic 

ahmadsa
Starting Member

7 Posts

Posted - 2007-12-12 : 14:17:18
Hotel (hotelNo, hotelName, city)
Room (roomNo, hotelNo, type, price)
Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)
Guest (guestNo, guestName, guestAddress)

can anybody give me the Relational Algebra for the following queries:

List the room numbers of all single rooms with a price below 20 per night


List the guest details of people staying at the Hilton hotel who will be checking out on 01-Sep-05

thanx i will be very grateful if anybody can help

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-12 : 16:27:58
Cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=94103



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -