Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions