Question: 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,

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, Room r
WHERE h.hotelNo _ r.hotelNo AND city _ ‘London’

Step by Step Solution

★★★★★

3.42 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

CREATE TRIGGER UpdateLondonHotelRoom INSTEAD OF INSERT ... 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 (1296).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

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...

Create an insert trigger that sets up a mailshot table recording the names and addresses of all guests who have stayed at the hotel during the days before and after New Year for the past two years.

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...

Tool doesn't matter. Consider the following database schema (primary keys are underlined) and SQL queries: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo....

1) Study the Wellmeadows Hospital case study presented in Appendix B.3 (attached). a) In what ways would a DBMS help this organization? b) What do you think are the main objects that need to be...

How to do this Database questions using Oracle? Given the following Relations Schema: (Primary key column(s) are underlined, decide on the required foreign keys.) Hotel (hotelNo, hotelName, city)...

Vital source: Art as LA ALEKS. Bo Waldru... Vitalsource: Art as L... 5 Letter from a Birmi... Lamar University Pr MISY 3310 - Access Assignment Total Points: 100 Premiere Products - Data Management...

1.3) Create a trigger, trg_customer_invoice, that increments num_invoices of the corresponding customer whenever a new invoice is added. 1.4) Create a trigger, trg_new_line, that is fired when a new...

Consider the following database schema (primary keys are underlined) and SQL queries: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo,...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

ILock, Inc., is authorized to issue 450,000 no par value common shares. On January 1, 2021, it offers an issue, on a subscription basis, of 100,000 common shares at $15 per share. Each subscriber is...

An individual stock's diversifiable risk, which is measured by its beta, can be lowered by adding more stocks to the portfolio in which the stock is held.

Consider the monthly returns of Petroleos Brasileiros stock ( or PBR ) and use the corresponding values of the S&P 5 0 0 as the respective market index. 1 . Create a scatter diagram to represent...

What are criticisms of Title VII?

For each of the three partitioning techniques, namely round-robin, hash partitioning, and range partitioning, give an example of a query for which that partitioning technique would provide the...

In a range selection on a range-partitioned attribute, it is possible that only one disk may need to be accessed. Describe the benefits and drawbacks of this property.

What factors could result in skew when a relation is partitioned on one of its attributes by: a. Hash partitioning b. Range partitioning In each case, what can be done to reduce the skew?

Listed below are systolic blood pressure measurements (in mm Hg) obtained from the same woman. Find the regression equation, letting the right arm blood pressure be the predictor (x) variable. Find...

Do you believe these statistics? why or why not. The first variable in healthcare that I work with is temperatures of my post-surgical patients.Solet's say thatI had 3 normal temperatures of 36.7,...

Use the following selected data from Business Solutions's income statement for the three months ended March 31,2022 , and from its March 31 . 2022 , balance sheet to complete the requirements....