Question: relational algebra solution - no tables please! Hotel Database Hotel (HotelNo, Name, Address) Room (RoomNo, HotelNo, Type, Price) Booking (HotelNo, GuestNo, DateFrom, DateTo, RoomNo) Guest

relational algebra solution - no tables please!

relational algebra solution - no tables please!

Hotel Database Hotel (HotelNo, Name, Address) Room (RoomNo, HotelNo, Type, Price) Booking (HotelNo, GuestNo, DateFrom, DateTo, RoomNo) Guest (GuestNo, Name, GuestAddress) 1. List the price and type of all rooms at the Grosvenor Hotel. 2. List all guests currently staying at the Grosvenor Hotel. 3. List the details of all rooms at the Grosvenor Hotel, including the name of the guest staying in the room if the room is occupied. 4. List the guest detail (GuestNo, Name, GuestAddress) of all guest staying at the Grosvenor Hotel. Project Databse 5. Produce a list of the names of all employees who work on SCCS project. 6. Produce a complete list of all managers who are due to retire this year. 7. Find out how many employees are managed by James Adam. 8. For each project on which more than two employees worked, list the project number, project name, and the number of employees who work on that project. 9. List the total number of employees in each department for those departments with more than 10 employees

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!