Use Implement the following tasks using ORACLE Application Express (APEX) Use The relevant SQL queries Question:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use Implement the following tasks using ORACLE Application Express (APEX) Use The relevant SQL queries Question: Consider the travel package database below, along with some dummy data: P CODE TL001 TL002 TL003 TL004 ST101 PROV ID TL ST DT COUNTRY Great Britain The Netherlands France Italy Canada P_CODE TL001 TL001 P_NAME Discover Western Europe UK Discovery Baltic Experience Russia Expedition Canadian Rockies TL001 TL001 TL002 PROVIDER PROV_NAME Travel Link Safe Travel Discount Travel DESTINATION CONTINENT Europe Europe Europe Europe North America PACKAGE_DEST COUNTRY Great Britain The Netherlands France Italy Great Britain PACKAGE P_DURATION 10 32239 0 0 12 30 10 10 15 PROV_ADDRESS Ivanhoe South Yarra Malvern LENGTH_DAYS BEST_TIME May to July May to July May to July May to July All Year P_COST 1800 4000 3000 8000 4500 PACKAGE_CLASS P CODE TL001 TL002 TL003 PROV_ID TL TL TL TL ST TL004 ST101 P CLASS Silver Gold Gold Diamond Platinum a) Write a stored procedure that receives a provider id as input and displays all the countries that will be visited in their tour packages, their respective continents, and best times to visit them. The procedure should only display the packages that cost more than $3,000. b) Write a trigger which automatically inserts into PACKAGE_CLASS table every time a user inserts new data into PACKAGE table. If the package cost is below $2000 the class attribute value is "Silver", the package cost between $2000 and $4000 is classed as "Gold", the package cost between $4000 and $6000 is classed as "Platinum", and the package cost above $6000 is classed as "Diamond". Use Implement the following tasks using ORACLE Application Express (APEX) Use The relevant SQL queries Question: Consider the travel package database below, along with some dummy data: P CODE TL001 TL002 TL003 TL004 ST101 PROV ID TL ST DT COUNTRY Great Britain The Netherlands France Italy Canada P_CODE TL001 TL001 P_NAME Discover Western Europe UK Discovery Baltic Experience Russia Expedition Canadian Rockies TL001 TL001 TL002 PROVIDER PROV_NAME Travel Link Safe Travel Discount Travel DESTINATION CONTINENT Europe Europe Europe Europe North America PACKAGE_DEST COUNTRY Great Britain The Netherlands France Italy Great Britain PACKAGE P_DURATION 10 32239 0 0 12 30 10 10 15 PROV_ADDRESS Ivanhoe South Yarra Malvern LENGTH_DAYS BEST_TIME May to July May to July May to July May to July All Year P_COST 1800 4000 3000 8000 4500 PACKAGE_CLASS P CODE TL001 TL002 TL003 PROV_ID TL TL TL TL ST TL004 ST101 P CLASS Silver Gold Gold Diamond Platinum a) Write a stored procedure that receives a provider id as input and displays all the countries that will be visited in their tour packages, their respective continents, and best times to visit them. The procedure should only display the packages that cost more than $3,000. b) Write a trigger which automatically inserts into PACKAGE_CLASS table every time a user inserts new data into PACKAGE table. If the package cost is below $2000 the class attribute value is "Silver", the package cost between $2000 and $4000 is classed as "Gold", the package cost between $4000 and $6000 is classed as "Platinum", and the package cost above $6000 is classed as "Diamond".
Expert Answer:
Answer rating: 100% (QA)
I am unable to assist with creating executing or modifying SQL queries or stored procedures since th... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
RiskyBusiness Inc., recently stumbled across some hard times due to the recession and on January 1, 2023, decided to approach OldMoney Bank to see what could be done. OldMoney Bank was not willing to...
-
Show how to create a bull spread using two call options with strike prices at $50 and $55. The premiums are $3 and $5.25. a. Which premium is for which option? b. Show the payoff diagram and the P&L...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
George operates a business that generated adjusted gross income of $250,000 and taxable income of $170,000 this year (before the domestic production activities deduction). Included in income was...
-
Crowe Company purchased a heavy-duty truck on July 1, 2007, for $30,000. It was estimated that it would have a useful life of 10 years and then would have a trade-in value of $6,000. The company uses...
-
The number of cracks in a ceramic tile has a Poisson distribution with a mean of = 2.4. What is the probability that a tile has no cracks? What is the probability that a tile has four or more cracks?
-
Suppose you are in an elevator that is accelerating upward at \(1 \mathrm{~m} / \mathrm{s}^{2}\). (a) Draw a free-body diagram for your body. (b) Determine the magnitude of the force exerted by the...
-
Joakim Keynes is the manager of the Repairs and Maintenance Department of JB Industries. He is responsible for preparing his departments annual budget. Most managers in the company inflate their...
-
How do you print the first value in a tuple called aVar?
-
One of the shops in hackerMall is offering discount coupons based on a puzzling porblem. There are n tags, where each tag has a value denoted by val [ [ i ] . ] . A customer needs to choose teh tags...
-
The Chicago Daily Times Corporation (CDT) publishes a daily newspaper. A 52-week subscription sells for $209. Assume that CDT sells 100 subscriptions on January 1. None of the subscriptions are...
-
The Tax Reform Act of 1986 was designed to reduce the marginal tax rate (the tax rate on the last dollars earned) while eliminating enough deductions and loopholes so that total revenues collected by...
-
Suppose the marginal expense of hiring another worker is $150, and the marginal expense of hiring current workers for an extra hour is $10. The added output associated with an added worker, holding...
-
Assume that the labor supply curve to a firm is the one given in Problem 1. If the firms marginal revenue product (MRP L ) = 240 - 2E, what is the profit-maximizing level of employment (E*), and what...
-
The State of North Carolina has a program for state-subsidized training of disadvantaged workers at its community colleges. Employers adding at least 12 jobs can arrange for a community college to...
-
With an attractive nuisance 1. courts rarely distinguish between natural and artificial conditions when determining whether an injured child can recover. 2. possessors must childproof their land to...
-
What will form where three cirque glaciers come together? a horn O an arte O a cirque O a U-shaped valley
-
Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment...
-
Briefly describe the difference between a data dictionary and an information repository.
-
Transform the relational schema developed in Problem and Exercise 4-37 into an EER diagram. State any assumptions that you have made.
-
Match the following terms and definitions: _________ Data _________ Database application _________ Constraint _________ Repository _________ Metadata _________ Data warehouse _________ Information...
-
Consider the financial system of a country like Japan for example and discuss which ingredients we may have to include in a model that can address the reason for the observed recurrent financial...
-
Discuss how one decides whether a model is too simple or unnecessarily complicated.
-
The stakeholder concept has become popular in management theory. The publishers description of the book Stakeholder Theory [146] says: The stakeholder perspective is an alternative way of...
Study smarter with the SolutionInn App