Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Probl Consider the following relational represent information about a hotel, employees, em 3. (20 points) Understanding of Relational Algebra ng relational schema from which the
Probl Consider the following relational represent information about a hotel, employees, em 3. (20 points) Understanding of Relational Algebra ng relational schema from which the underlined fields represent the keys to rooms, and guests Guest (guestld: GuestStay integer, name: string, address: string) - Hotel guests. tay(guestld: integer, check-in-date: date, check-out-date: date, roomld: integer)- Guest reservation history mployee (employeeld: integer, e-name: string) - Hotel employees - Hotel rooms Receptionist (employeeld: integer, desk-type: string, hours-per-day: double) - Hotel Room (roomld: integer, floornumber: integer, room-capacity: integer, empty: Boolean) receptionists Cleaning-Staff (employeeld: integer, floornumber: integer, hours-per-day: double) Assignment of floors to clean. Cleaning-Assignment (employeeld integer, roomld: integer); - Assignment of rooms to clean Using this schema, answer the following questions: a) (5 pts) Write a relational expression for the following query Find the name and employee number for all employees who are receptionists Find the average capacity of rooms in each floor cleaned by the staff member with employee id 123. b) (5 pts) Write a relational expression for the following query
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started