Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 3. (20 points) Understanding of Relational Algebra Consider the following relational schema from which the underlined fields represent the keys to represent information about
Problem 3. (20 points) Understanding of Relational Algebra Consider the following relational schema from which the underlined fields represent the keys to represent information about a hotel, employees, rooms, and guests Guest (questld: integer, name: string, address: string) Hotel guests GuestStay(questld: integer check-in-date: date, check-out-date: date, roomld integer) - Guest reservation history Employee (employeeld:integer, e-name: string) Hotel employees Room (roomld: integer, floornumber: integer, room-capacity: integer, emp - Hotel rooms Receptionist (employeeld: integer, desk-type: string, hours-per-day: double) Hotel receptionists Cleaning-Staff (emploveeld: integer, floornumber: integer, hours-per-day: double)- Assignment of floors to clean Cleaning-Assignment (employeeld integer, roomld: integer); Assignment of rooms to ty: Boolean) 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 b) (5 pts) Write a relational expression for the following query: Find the average capacity of rooms in each floor cleaned by the staff member with employee id 123
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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