Question: Create a database trigger for the following situations: (a) The price of all double rooms must be greater than 100. (b) The price of double

Create a database trigger for the following situations:
(a) The price of all double rooms must be greater than £100.
(b) The price of double rooms must be greater than the price of the highest single room.
(c) A booking cannot be for a hotel room that is already booked for any of the specified dates.
(d) A guest cannot make two bookings with overlapping dates.
(e) Maintain an audit table with the names and addresses of all guests who make bookings for hotels in London (do not store duplicate guest details).

Step by Step Solution

★★★★★

3.30 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a CREATE TRIGGER DouleRoomPrice BEFORE INSERT ON Room FOR EACH ROW WHEN newtype D AND newprice 100 B... 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 (1295).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Draw an entity relationship diagram (ERD) for the following situations: 1. Whenever new patients are seen for the first time, they complete a patient information form that asks their name, address,...

Create an INSTEAD OF database trigger that will allow data to be inserted into the following view: CREATE VIEW LondonHotelRoom AS SELECT h.hotelNo, hotelName, city, roomNo, type, price FROM Hotel h,...

1. Create a view named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and OwnerNum columns in the MarinaSlip table for those slips with lengths of 40 feet. Display the data...

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

Assume a new table has been created with tablename: RoomCount (hotelNo, hotelName, numOfRooms, avgPrice). Create the table using the following query: CREATE TABLE RoomCount (hotelNo VARCHAR(3),...

Compare and contrast the exercise procedure for stock options with that for index options. What major advantages does exercising an index option have over exercising a stock option?( refer attached...

You are tasked to write a Java program that filters a list of products using Predicate and negate ( ) methods. The program should receive a list of products and two predicates. The first predicate...

I am having a difficult time and I have another one and I am almost done with the class in 2 week Chapter 9: Discussion Questions (Pg 404-405) 2. What are some of the purposes of budgeting? 4....

Production yield data with 17 degrees of freedom have been collected. Find the appropriate t value from the t table to use for each of the following confidence interval calculations: a. One-sided 95%...

Morning Machine Works has obtained a contract from the government to manufacture special parts for a new military aircraft. The parts are to be delivered over the next five years, and the company...

the company can always leave the capital investment in the stock portfolio, which is projected to yield 8 % p . a . over the next seven years. What should the company do ?

Which committee created the Basel Accords?

Compute r x s for the relations as shown below. O llen en 211 4150

Given that the LDAP functionality can be implemented on top of a database system, what is the need for the LDAP standard?

Describe how LDAP can be used to provide multiple hierarchical views of data, without replicating the base level data.

The most recent financial statements for Schenkel Co. are shown here: The most recent financial statements for Schenkel Co. are shown here: Assets and costs are proportional to sales. Debt and equity...

The management of the SummerIsAlmostHere Company needs to estimate the cost of its equity financing. The latest financial data is as follows: stock price of $25.00; next expected dividend is $1.25...

Problem 8 - 1 9 Value a Constant Growth Stock ( LG 8 - 5 ) Financial analysts forecast Safeco Corp. ' s ( SAF ) growth rate for the future to be 1 2 percent. Safeco's recent dividend was $ 1 . 5 0 ....