The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.

The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.

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

Related questions

Q: Task 4: Use the IN operator to find the ID, first name, and last name of each customer for which as…

A: The above question is solved in step 2 :-

Q: The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the…

A: DAY(DATE) returns day number in dd format example 25 MONTH(DATE) returns month number in mm format,…

Q: Please recheck the answer, since in the before solution for the same question, you answered using…

A: The query is correct that the algorithm provided in the previous answer describes a breadth-first…

Q: Task 4: Use the IN operator to find the ID, first name, and last name of each customer for which as…

A: Task 4 GROUP BY is used to group result as per the column specified. Note - Table data is to be…

Q: g the INSERT command do the following 1- Make at least 5 problems, with one called “LOW” and one…

A: Hey there, I am writing the required solution of the questin mentioned above. Please do find the…

Q: If you can't remember where the update.txt file is on your machine, print it out.

A: As a subject matter expert, I understand that locating a specific file on a computer system can…

Q: The DumpMem procedure requires what input parameters?

A: "Dumpmem" referrs to the computer program which is majorly designed to perform memory dump. It is…

Q: Assume that there are 12 records in training data and there are three classes: C1, C2, and C3. Write…

A: We need to find the number of records in each class so that the Gini index is maximum.

Q: The primary distinctions between MonthCalendar and DateTimerPicker are detailed below.

A: Both MonthCalendar and DateTimePicker are controls available in the Microsoft .NET framework for…

Q: Rewrite the following read csv method to index columns 1 and 3. Then sort the indexes. Then write…

A: Read the "exama.csv" file using pd.read_csv() method and store it in a variable named examclub. Use…

Q: Write a script that creates and calls a stored procedure named insert_category. First, code a…

A: The question requires us to write a script that creates and calls a stored procedure named…

Q: You need to return all travel data from the TRAVELS table for the CAR_ID which has a plate number…

A: Here, you need to join both the tables with same car_id whose car_plate is BB-883-***

Q: 12 return: ERROR 1410 (42000) at line

A: Given : Task 11 & 12 return: ERROR 1410 (42000) at line 1

Q: After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides to…

A: Given: After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides…

Q: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name,…

A: Hi there, Please find your solution below, I hope you would find my solution useful and helpful.…

Q: Write an Add method that adds the contents of the decPrice variable to the lstPrices control.

A: Add method The add method is used to add a specific element. The function is used to add the…

Q: Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on…

A: SQL query to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

Q: In the same text file you created in step 2, add SQL commands to insert the sample records (given…

A: Here is the query : INSERT INTO Doctor VALUES (5040, ‘ Sam Rathod ’ , ‘ 1234567890 ’ , null , ‘…

Q: Hold commands can't be chosen until another condition is met.

A: When a command is unsupported or absent from the system, it is considered unavailable. This example…

Q: Write a script that creates and calls a stored procedure named spInsertDepartment. First, code a…

A: Answer : Stored Procedure : /*creating stored procedure*/create procedure…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: The InstantRide received some traffic violation tickets from the government. The Legal team of…

A: LEFT JOIN is a type of join which returns all the contents(rows) from the left table and the…

Q: entered a formula into the range O6:O10 to calculate the highest amount of each set sold over the…

A: Microsoft Excel is a powerful spreadsheet software used for data visualization and analysis. It is…

Q: Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the…

A: Given : Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of…

Q: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing…

A: sql command for the question is given in step 2

Q: Task 3: StayWell is offering a monthly discount for residents who pay their rent on a quarterly…

A: 1: Select the columns OFFICE_NUM, ADDRESS, OWNER_NUM. LAST_NAME, MONTHLY_RENT in the PROPERTY table…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: SQL: SQL (Structured Query Language) is a domain-specific programming language designed to…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

100%

The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in
the database. However, the team wants to calculate the VAT after the discounts are
applied on the prices. In addition, it is important to remember if there is no
discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called
VATCalculator to calculate the VAT amount and return with the corresponding travel ID.
In addition, execute the procedure to account for NULL values and send the respective
result to the team. The VAT value should be rounded to 2 decimals.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Procedure

VIEW

Explanation

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests beforehand. You will need to return all the property IDs and the addresses of the properties that had plumbing service request (CATEGORY_NUMBER 1). Task Return a list of all the property IDs and the addresses of the properties that had plumbing service requests.
Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)
We had to create a directive to validate maximum values since max only prevents scrolling up past the maximum value. True False
Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
In Android Studio, db is a SQLiteDatabase reference; sql is a String representing a delete SQL statement. Write a statement to execute that SQL statement.
"Create a stored procedure named spPriceRange that accepts two optional parameters. Theprocedure should return a result set consisting of Product Id, Product Name, ProductDescription, and List Price from the product and product description tables for each productwithin the price range, sorted with largest price first. The parameter @PriceMin and @PriceMaxare parameters used to specify the requested range of prices. If the minimum price is notprovided use the minimum non-zero price in the product table. If the maximum price is notprovided use the maximum price in the product table."
The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.
Update the validateForm() function to verify the phone number is exactly 10 characters long. Display "Phone number is invalid" in the console log if the phone number does not meet the requirements. Use the preventDefault() function to avoid submitting the form when the input is invalid.
. Write a stored procedure named printOrderFreights(). The printOrderFreights()procedure should use cursor processing to find those orders whose freight is less than or equal to 0.2 and then print the “Freight is less than or equal to $0.2” message for each and every row that satisfies the condition. Hint: You need to use cursor processing for this stored procedure. Hint: Follow the 5 steps of cursor processing and declare any variables needed.
Task 3: The Marketing team wants to collect emails of the users on InstantStay. However, the team needs a SQL statement to execute inside their programming environment. You need to create a statement that they can easily run the EXECUTE command to return a single column table containing the USER_EMAIL addresses. Task: Create a prepared statement for use with the EXECUTE command.