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 06:00
Which of the following is a way that advancements in technology improve humans' ability to measure air quality and protect human health? a. air quality data gathered by new instruments can be used to reduce exposure to pollutants. b. new technologies enable natural and human-made pollution sources to be located and monitored. c. air quality data gathered by new instruments can be used to predict trends in pollution over time. d. new technologies allow governments to make informed decisions about the regulation of pollution. (choose more than one)
Answers: 2
question
Computers and Technology, 23.06.2019 02:00
For a typical middle-income family, what is the estimated cost of raising a child to the age of 18? $145,500 $245,340 $304,340 $455,500
Answers: 1
question
Computers and Technology, 23.06.2019 08:00
What is a scenario where records stored in a computer frequently need to be checked
Answers: 2
question
Computers and Technology, 23.06.2019 11:00
In the context of the box model, what is the difference between a margin and a padding? a. a padding lies outside a box border, while a margin lies inside it. b. a padding lies inside a box border, while a margin lies outside it. c. a padding can be adjusted independently, while a margin depends on the size of its box. d. a padding depends on the size of its box, while a margin can be adjusted independently.
Answers: 3
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
Mathematics, 10.04.2021 18:50
question
Social Studies, 10.04.2021 18:50
question
English, 10.04.2021 18:50
question
Mathematics, 10.04.2021 18:50
question
Mathematics, 10.04.2021 18:50