subject

Now that you have all the information you need in your system, you need to write a procedure to automate the grading of students. Assignment: 1. Create a PL/SQL Procedure to assign grades to your registered students. Use the following guidelines for providing a grade scale for your students: Rule: A - Class Title ends with a character between A-F B - Class Title ends with a character between G-K C - Class Title ends with a character between L-P D - Class Title ends with a character between Q-T E - Class Title ends with a character between U-Z Hint: Use a PL/SQL Procedure (cursor to loop through the records, check the class title, then update the grade table). . BE SURE TO WRITE A VIEW THAT DISPLAYS THE FOLLOWING INFORMATION: STUDENT ID STUDENT NAME COURSE NAME/TITLE SECTION ID CREDIT HOURS DAYS START TIME END TIME START DATE END DATE BUILDING/ROOM INSTRUCTOR FIRSTNAME, LASTNAME GRADE

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 07:30
By refraining from constructing a building until they are certain that it will not cause harm to the environment, an organization is adhering to the
Answers: 2
question
Computers and Technology, 23.06.2019 15:00
Barbara is interested in pursuing a career in the science and math pathway. which qualifications will her reach that goal? a.an advanced knowledge of physics and math b.an advanced knowledge of engineering and math c. an advanced knowledge of physics and robotics an d. advanced knowledge of machinery and math
Answers: 2
question
Computers and Technology, 23.06.2019 21:30
Enzo’s balance sheet for the month of july is shown. enzo’s balance sheet (july 2013) assets liabilities cash $600 credit card $4,000 investments $500 student loan $2,500 house $120,000 mortgage $80,000 car $6,000 car loan $2,000 total $127,100 total $88,500 which expression finds enzo’s net worth?
Answers: 1
question
Computers and Technology, 23.06.2019 23:00
Lucas put a lot of thought into the design for his company's new white paper. he made sure to include repeating design elements such as color schemes and decorative images. his goal was to a.add symmetry b.create a unified publication c.provide consistency d.save money
Answers: 1
You know the right answer?
Now that you have all the information you need in your system, you need to write a procedure to auto...
Questions
question
Business, 29.05.2021 14:40
question
Arts, 29.05.2021 14:40
question
Computers and Technology, 29.05.2021 14:40
question
Computers and Technology, 29.05.2021 14:40
question
Biology, 29.05.2021 14:50
question
Mathematics, 29.05.2021 14:50
Questions on the website: 13722363