1 Create a function called convert numeric grade that converts a numeric grade to a letter grade Use a CASE structure Accept a numeric grade as the input parameter and return a letter grade Use the following rules A 90 B 80 C 70 D F 60 60 2 Create an anonymous block that invokes convert numeric grade Prompt for the numeric grade and pass as a parameter to convert numeric grade Return the letter grade and output as shown below Input ENTER NUMERIC GRADE 75 Output Numeric grade 75 Letter grade C Exercise 2 1 GET FULL NAMEfunction Create a function called get full name Pass the student number as a parameter to get full name Access the STUDENTS table and return the full name Example Joe Smith Include an EXCEPTION section to check for NO DATA FOUND If the NO DATA FOUND error occurs, RETURN a NULL value 2 Create an anonymous block that invokes get full name Prompt for the student id and pass as a parameter to get full name Return the student's full name and output as shown below If the student is not found, NULL is returned from the function If NULL is returned, do not output the full name Instead output a message indicating the student was not found Also, include a catch all handler that displays the error code and error message

The Answer is in the image, click to view...

Question: 1. Create a function called convert_numeric_grade that converts a numeric grade to a letter grade. Use a CASE structure. Accept a numeric grade as

a letter grade. Use a CASE structure. Accept a numeric grade as

1. Create a function called convert_numeric_grade that converts a numeric grade to a letter grade. Use a CASE structure. Accept a numeric grade as the input parameter and return a letter grade. Use the following rules: A: >= 90 B: >= 80 C: >= 70 D: F: >= 60

Step by Step Solution

★★★★★

3.57 Rating (154 Votes )

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 Computer Engineering Questions!

Hypothesis Test - One Proportion Sample Size Successes Proportion Null Hypothesis: Alternative Hyp: Difference Standard Error Z (uncorrected) Z (corrected) Exact Test 75 4 0.05333 P = 0.5 P = 0.5...

Blossom Salon Supply Company has accounts receivable of $89,000 at March 31, 2025. An analysis of the accounts shows these amounts: Balance, March 31 Month of Sale 2025 2024 March $60,000 $75,000...

Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...

Copper Products Limited leases property on which copper has been discovered. The lease provides for an immediate payment of $472,000 to the lessor before drilling has begun and an annual rental of...

A small country's protectionism can be summarized: The typical tariff rate is 50 percent, the (absolute value of the) price elasticity of demand for imports is 1, imports would be 20 percent of the...

23. According to TruEarths Isabel Eckstein, product for the whole family, convenient, easy to prepare, fresh taste, variety, quality of ingredients, and healthiness of ingredients are all independent...

Machine 1 is currently working. Machine 2 will be put in use at a time t from now. If the lifetime of machine i is exponential with rate i,i = 1, 2, what is the probability that machine 1 is the...

Laser Delivery Services, Inc. (LDS) was incorporated January 1. The following transactions occurred during the year: a. Received $ 40,000 cash from the companys founders in exchange for common stock....

Dont copy paste previous solutions please. 1. The state of 0.5kg of steam (Cp=2kJkg1K1) is changed from saturated vapor at 10 bar to superheated vapor at 35 bar and 537C. Calculate the enthalpy and...

An entrepreneurial venture's positioning strategy is all about determining in which channels and retailers a product will be sold. 1) True 2) False Question 12 ( 3 points) If your research objective...

Acme Pty Ltd is a company involved in residential property development in southern Sydney. Acme purchases older style properties and then demolishes the houses and converts the properties into...

evaluate Davis and Inajimas (2021) article and critically discuss the contributions of current research within the fields of management accounting

While driving his vehicle, Herb approaches a red stoplight but his brakes do not respond when he presses on the brake pedal. As a result, the front of Herb's car hits the rear of Clara's car. Clara's...

If you can help with me with all the questions. Please & Thank you Chapter 1 What Economics is About & Appendix A: Pre-Class & In-Class Activities Packet Name/I.D. Number:_ Section: Date: Part 1....

The company sold $900,000 of products on account [The product cost was $600,000}. It subsequently collected 90% of the amount owed by customers, The company paid the account payable balance in...

DL Company's Statement of Financial Position and Income Statement in 2019 are shown below. DL Company Statement of Financial Position December 31 2019 2018 $27,020 47,000 98,000 86,980 220,500...

In what ways does a well-designed enterprise search software vary from popular search engines (e.g., Bing, DuckDuckGo, and Google)?

The elementary gas-phase reaction A B takes place isobarically and isothermally in a PFR where 63.2% conversion is achieved. The feed is pure A. It is proposed to put a CSTR of equal volume upstream...

A reaction is to be carried out in the packed-bed reactor shown in Figure P12-19C. PFR with heat exchange. The reactants enter the annular space between an outer insulated tube and an inner tube...

If you used the Boussinesq (or Westergaard) theory for Problem 10.1, do the problem again but use the Westergaard (or Boussinesq) theory instead. Comment on the differences between the two theories.?

A central tension exists between evolutionary approaches to emotion, which posit that emotions are biologically based and universal, and a constructivist approach, which holds that the meaning of...

Happiness is associated with many benefits, including stronger relationships, increased creativity, and better health.

Emotions are defined by their appraisals, experiences, expressions, and physiological patterns.