Consider the following relations in a Hotel database. Hotel (HotelNo, HotelName, Address, Capacity) Booking (CustomerNo, HotelNo, Date, NumberOfGuests). HotelNo is the primary key of the Hotel relation. Assume that (1) a customer can book the same hotel on different dates; (2) a customer can book multiple hotels on each date; (3) a hotel can be booked by multiple customers on each date. What is the most suitable primary key for the Booking relation? Justify your answer. Write the SQL statement to define an assertion BookLimit that ensures "each customer cannot book more than 3 hotels on each (1) (2) date". (3) Write the SQL statement to define an assertion CapacityLimit that ensures "the total number of guests booked for each hotel on each date cannot exceed the hotel capacity".

Consider the following relations in a Hotel database. Hotel (HotelNo, HotelName, Address, Capacity) Booking (CustomerNo, HotelNo, Date, NumberOfGuests). HotelNo is the primary key of the Hotel relation. Assume that (1) a customer can book the same hotel on different dates; (2) a customer can book multiple hotels on each date; (3) a hotel can be booked by multiple customers on each date. What is the most suitable primary key for the Booking relation? Justify your answer. Write the SQL statement to define an assertion BookLimit that ensures "each customer cannot book more than 3 hotels on each (1) (2) date". (3) Write the SQL statement to define an assertion CapacityLimit that ensures "the total number of guests booked for each hotel on each date cannot exceed the hotel capacity".

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What are the top five email "dos" and "don'ts," in your opinion, and how would you go about illuminating each?
How do you feel about Internet authenticity?
What measures can be taken to avoid race conditions?
What are the opinions of those who work in information technology about the usage of encrypted email?
Do you believe the government and law enforcement organizations should have access to user accounts on social media platforms like Facebook in order to investigate potential unlawful activity? What precisely is happening here?
Is cloud security compromised by a data breach? Is there anything you can tell me about countermeasures?