User Profile

Collapse

Profile Sidebar

Collapse
mixyguy6
mixyguy6
Last Activity: Aug 25 '05, 01:44 AM
Joined: Aug 25 '05
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mixyguy6
    started a topic SQL query
    in General

    SQL query

    SQL query for

    List the guest details (Guest_No, Name, and Address) of all guests staying at the Grosvenor Hotel.
    Hotel (hotelNo, hotelName, city)
    Room (roomNo, hotelNo, type, price)
    Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)
    Guest (guestNo, guestName, guestAddress)
    See more | Go to post
    • mixyguy6
      started a topic relational algebra query
      in General

      relational algebra query

      G'day

      my question is

      Hotel (hotelNo, hotelName, city)
      Room (roomNo, hotelNo, type, price)

      How u will
      (a) List all hotels in Canberra that has at least one double room.


      Projection ∏

      Selection σ

      Join
      See more | Go to post
      No activity results to display
      Show More
      Working...