Question: Now create the Room, Booking, and Guest tables using the integrity enhancement features of SQL with the following constraints: (a) Type must be one of

Now create the Room, Booking, and Guest tables using the integrity enhancement features of SQL with the following constraints:
(a) Type must be one of Single, Double, or Family.
(b) Price must be between £10 and £100.
(c) roomNo must be between 1 and 100.
(d) dateFrom and dateTo must be greater than today’s date.
(e) The same room cannot be double booked.
(f) The same guest cannot have overlapping bookings.

Step by Step Solution

★★★★★

3.45 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

CREATE DOMAIN RoomType AS CHAR 1 CHECKVALUE IN S F D CREATE DOMAIN HotelNumbers AS HotelNumber CHECK... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

672-CS-DB (1278).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Create the Hotel table using the integrity enhancement features of SQL.

Create the Projects schema using the integrity enhancement features of SQL with the following constraints: (a) Sex must be one of the single characters M or F. (b) Position must be one of Manager,...

Using the Hotel schema given at the start of the Exercises at the end of Chapter 4, determine whether the following queries are semantically correct: (a) SELECT r.type, r.price FROM Room r, Hotel h...

Now create the Room, Booking, and Guest tables using the integrity enhancement features of SQL with the following constraints: ( a ) type must be one of Single, Double, or Family. ( b ) price must be...

2. (30 points) Using the following tables that are a part of a database held in a relational DBMS: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guest No,...

b and c 2. (30 points) Using the following tables that are a part of a database held in a relational DBMS: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guest...

The following tables form part of a database held in a relational DBMS: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, roomType, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)...

. Create the following tables using the integrity enhancement features of SQL with the following constraints. Use the domains that you created in question 1. a. (5 points) Create the Hotel table...

The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientno, patName, patAddr, DOB) Ward (wardNo, wardName, wardType, noofBeds)...

Using the following tables that are a part of a database held in a relational DBMS: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo,...

Identify the C3H5Br isomers on the basis of the following information: (a) Isomer A has the 1H NMR spectrum shown in Figure 13.40.

What happens when the value of dollar drops? Group of answer choices The earnings of a U.S. company with international operations increase. The earnings of a U.S. company with national operations...

8. Record the following transactions of Alinas Designs in a general journal: DATE TRANSACTIONS 20X1 April 1 Purchased merchandise on credit from Global Fabricators, Invoice 885, $2,400, terms 1/10,...

To what is the continued decline during the Great Depression attributed?

For each of the following protocols, describe aspects of practical applications that would lead you to suggest using the protocol, and aspects that would suggest not using the protocol: Two-phase...

Under a modified version of the timestamp protocol, we require that a commit bit be tested to see whether a read request must wait. Explain how the commit bit can prevent cascading abort. Why is this...

Under what conditions is it less expensive to avoid deadlock than to allow deadlocks to occur and then to detect them?

Paladin Furnishings generated million in sales during 2019, and its year and total assets were $2.8 million. Also, at year-end 2019, current liabilities were $500.000. consisting of $200,000 of notes...

(1 point) Random samples of female and male drivers are asked to estimate the number of miles that each drives in a year. The data is below: Females (Population 1): 9100, 8100, 9500, 790, 8100, 8400,...

How to calculate the content of green grid? Thank you 12. After saving diligently throughout your entire career, you and your spouse are finally ready to retire with a nest egg of $1,000,000. You...