For the following exercises, use the Hotel schema de?ned below. Hotel (hotelNo,
ID: 3537166 • Letter: F
Question
For the following exercises, use the Hotel schema de?ned below. Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress) where Hotel contains hotel details and hotelNo is the primary key; Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key; Booking contains details of the bookings and (hotelNo, guestNo, dateFrom) forms the primary key; and Guest contains guest details and guestNo is the primary key. 5.8 Describe the relations that would be produced by the following relational algebra operations: (a) ?hotelNo(?price>50(Room))Explanation / Answer
what I understood from your question is given below
CREATE SCHEMA hotelinfo
SET SCHEMA hotelinfo
CREATE TABLE hotel (
hotelNo INTEGER NOT NULL PRIMARY KEY,
hotelName VARCHAR(200) NOT NULL,
city VARCHAR(100) NOT NULL)
CREATE TABLE room (
roomNo INTEGER NOT NULL,
hotelNo INTEGER NOT NULL REFERENCES hotel,
type VARCHAR(10) NOT NULL
CHECK (type IN (%u2019single%u2019, %u2019double%u2019, %u2019family%u2019)),
price NUMERIC(3, 2) NOT NULL
CHECK (price BETWEEN 10 AND 100),
PRIMARY KEY (roomNo, hotelNo))
CREATE TABLE guest (
guestNo INTEGER NOT NULL PRIMARY KEY,
guestName VARCHAR(200) NOT NULL,
guestAddress VARCHAR(1000))
CREATE TABLE booking (
hotelNo INTEGER NOT NULL REFERENCES hotel,
guestNo INTEGER NOT NULL REFERENCES guest,
dateFrom DATE NOT NULL,
dateTo DATE NOT NULL,
roomNo INTEGER NOT NULL,
PRIMARY KEY (hotelNo, guestNo, dateFrom),
FOREIGN KEY (hotelNo, roomNo) REFERENCES room,
CHECK (dateFrom <= dateTo),
CHECK (NOT EXISTS (
SELECT * FROM booking b1, booking b2
WHERE b1.hotelNo = b2.hotelNo
AND b1.guestNo = b2.guestNo
AND b1.dateFrom < b2.dateFrom
AND b1.dateTo > b2.dateFrom)))
If you were looking for something else let me know