Question: Using the views vhotel, vroom, vguest and vbooking, code a function that calculates the cost of a guest's stay given a bookingno as a parameter.

Using the views vhotel, vroom, vguest and vbooking, code a function that calculates the cost of a guest's stay given a bookingno as a parameter. Call the function BOOKINGPRICE(). The function take an input INT parameter of the bookingNo and calculates the booking price using the formula:

Cost of Stay = No of Days * Price of room/Day L> booking.room.price column | datediff(Checkout date,Checkin Date) 4. Test your results by running a query that reports the booking price and the following columns. Report should be for all bookings. Pass the bookingNo to the bookingprice() function in the SQL, and use bookingprice() function to calculate the tax and service charge. Hotel Name, Guest Name, Check-in Date, Check-out Date, Price of Stay, Tax, Service charge

Where tax is bookingprice * .875 and service charge is bookingprice * .18.

What is the SQL code to be able to see the reports booking while using the function?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. we need to alter an existing table and adding a bookingno that is auto-numbered. Design steps to save the current data of the booking table to another table, alter the booking table to add the new...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Question 1 (3 points) Saved When performing a single-row INSERT statement, if you omit the list of columns into which the data will be inserted: The INSERT operation will fail You should specify the...

Create any two related tables of your choice and insert at least two records in each of the table. Tables should include primary key and foreign key column(s). Demonstrate the usage of views by...

Problem 8-III-3 Counter Sink Holes Configure & plot an ANSI D size layout Three standard views, front, side, & top. Hint is to do the front view first to locate the back of the slot. Do not include...

ABC Mortgage had a major problem; HWY 40's continualconstruction created a nightmare for employees in the South St. Louis location on Hampton Avenue. All the employees lived outside the city and took...

Assignment 05: Interface for Movie Quote Generator For this assignment, you will build the interface for a Movie Quote Generator app. This assignment will be used as the starting point for the next...

ABC Mortgage had a major problem; HWY 40's continual construction created a nightmare for employees in the South St. Louis location on Hampton Avenue. All the employees lived outside the city and...

Fill in missing orthographic views. Using isometric views, draw orthographic views. Overall Dimensions of both figures: L = 6 c m W = 4 c m H = 4 c m

stion 1 A school library keeps track of book loans using a re lational database which has tables called Books, Borrowers and Loans. Parts of these tables are shown below Books Book ID Book Title...

Enzyme activity application questions: Compare the relative activity of a lysosomal enzyme at pH 5 vs. pH 7. Explain. Compare the relative activity of a cytosolic enzyme at pH 5 vs. pH7. Explain...

Express the complex number, 1- 13 i into polar form. -2e 2e -2e'a Ze

2 9 Each of the following are reported as fiduciary funds except. 0 1 : 2 8 : 3 9 Multiple Choice A permanent fund. An investment trust fund. A custodial fund. A private - purpose trust fund.

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

The banks. As major shareholders in privatized companies, and creditors of technically bankrupt companies, banks have a say in systems of ownership and control, and the nature of the company policy...

A lack of commitment to the organization. Western managers can help to foster organizational commitment through promoting the organization as a stable ongoing entity, which employees and managers can...

Lack of personal accountability and responsibility. Rewards can be tied to effort.