Question: Write a function in oracle sql that will assign a letter grade. Use the following grading schema. F = 0-60 D = 60-70 C =

Write a function in oracle sql that will assign a letter grade. Use the following grading schema. F = 0-60 D = 60-70 C = 70-85 B = 85-92 A = 92+ The first number in the range is inclusive. In other words, 60 should be 'D'. 92 should be 'A'. You're going to have to set up a table... name it 'Grade_schema'. I don't want the values to be hard-coded in a function. Deliverables: Table - Grade_schema... with the insert statements to build the ranges Function - fn_assign_lettergrade(numeric grade_value) to return the corresponding letter grade.

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!

Written in C Write a program that reads students names followed by their test scores (Grade.txt). The program should output each students name followed by the test scores and the relevant grade. It...

CUSTOMERS \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|l|} \hline Customerld & FirstName & LastName & Address & City & Region & Country & PostalCode & Phone & Email \\ \hline \end{tabular} INVOICES...

Instructions: 1. Solve problem 5.1, 5.2, 5.3 and problem 5.4 given in Lab Manual No. 3. 2. Write the solution of problem 5.1, 5.2, 5.3 and problem 5.4 in "vi editor. Take the screenshot and put the...

Here are definitions of sequences and trees with integer elements: type iseq = Nil | Cons of int * (unit -> iseq) type itree = Leaf of int | Branch of itree * itree (a) In an ascending sequence such...

Multiple Chices Questions: 36. A subquery that executes once for each row in the outer query is known as a(n) ________. a. nested subquery b. correlated subquery c. defined subquery d. grouped...

Hi I need help with SQL, can you please help me with the following, Thank you.... 1.Write a SQL statement that returns the artist id and artist name that is associated with the tack having the...

ORACLE PL/SQL PROJECT..... In this file, write a function called get_classroom_teacher(). The function should take four IN parameters: the subject the school name the year a class is taught the...

Please answer and show code output for each part of the question 1. Write Your Own Function - SCAD penalty function (40 points) SCAD penalty function is defined as: if |x| $ 1 if 1 3 This function is...

Oracle Sql Task 0: Run bookstore.sql to create and populate tables: Author(a_name, gender, age, nationality) Book(isbn, title, ver_no, publisher) Writtenby(isbn, a_name, yr_published, price, no_copy)...

JAVA O This is a programming assignment to conduct experimentation on hash tables. The program must be written in Oracle Standard Edition compliant Java Part 1 Implement the following linear...

Pie Corporation acquired 70 percent of Slice Company's common stock on December 31, 20X5, at underlying book value. The book values and fair values of Slice's assets and liabilities were equal, and...

An acceptance sampling procedure is being developed to check whether batteries have the required voltage. The batteries are shipped in very large batches, and the voltages of a random sample of n =...

Julie and Lisa are sisters. Julie is a CPA auditing ACME semiconductor where Lisa is an employee and Julie is considered a covered member on the ACME audit. Julie s independence is impaired if...

After complaining about fatigue, Bua's friend shared some information with her about the benefits of regular exercise. After this conversation, Bua registered for a membership in the neighborhood...