Question: - Write a stored function that takes the name of the city where the patient lives. The value return will be based on the following

- Write a stored function that takes the name of the city where the patient lives. The value return will be based on the following table:

City	Discount
Carbondale	20%
Anna	10%

No discount is given to patient that lives in any other cities. Call this function from anonymous block. Allow the user to enter the patient ID. Calculate and display the amount that the patient has to pay.

Expected output:

Enter the patient ID: 331

He/she is the patient of Dr. Smith

Charge per appointment for Dr.Smith is RM 25 Please pay only : RM 22.5

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!

Please answer with the vlookup formula needed for the "Customer Status" in Part 3 and formulas needed for Parts 4-6 (ignore parts 1-2). Part 1: ETL with the OrderId field Let's decide that the rule...

home / study / engineering / computer science / computer science questions and answers / please do not spam answer me like other chegg people ... Question: Please do not spam answer me like other...

All of them Please write stored procedures and stored functions based on the dreamhome database. You must create and test your programs on database CPS3740 2017S at server imc.kean.edu. Your program...

Data Management and Data Analytics . Objective of the project . Base SAS Programming Using SAS Studio on SAS Viya C. SAS Visual Data Mining and machine Learning (In some questions Base SAS...

6.1. Carbondale Company has the following credit policy 2/10, net 30. Carbondale also charges 1% per month interest on all accounts after 30 days. The following table shows the collection schedule of...

Starting CODE(C++ code) #include #include #include #include using namespace std; //client_type class for storing all the relevant information of a client //client_type default constructor...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

A City Electric Utility Enterprise Fund made its annual interest payment on its outstanding $20 million of 6% bonds, which were originally issued at a premium. Assuming the City maintains it books...

Complete this page, thank you! Label the diagram of the human heart below. -IL 12. a Analysis Questions 1. How can you tell which side of the heart is the ventral surface? 3. Which chambers are the...

1 4 The lowest rating a bond can recelve from Standard and Poor's and still be classified as an investment quality bond is: Multiple Choice 3 point: 6 6 4 8 3 0 A . 6 ne en Be

Cashiers who work at the local grocery store are actors in the _____. Multiple choice question. factor market public market goods market

=+ 2. In the steady state of the Solow model, at what rate does output per person grow?

=+ a. Express output per worker (y = Y/L) as a function of capital per worker (k = K/L) and the natural rate of unemployment (u).

=+ b. Write an equation that describes the steady state of this economy. Illustrate the steady state graphically, as we did in this chapter for the standard Solow model.