PL/ SQL / ORACLE / CHAPTER2/HANDS-ON ASSIGNMENTS PART II page 83

Create a file named chapter2.sql that contains the PL/SQL code for assignments 2-9 and 2-11 as described in the *Hands-On Assigments Part II* section on page 83 of the textbook.

Declare and initialize variables to hold values for the Payment Due Date, Monthly Payment Amount and Number of Total Payments.

Please m ake sure to include a comment with your name in the file.

Hands-On Assignments Part II Assignment 2-9: Using a FOR Loop Create a PLISQL block using a FOR loop to generate a payment schedule for a donor's pledge, which is to be paid monthly in equal increments. Values available for the block are starting payment due date, monthly payment amount, and number of total monthly payments for the pledge. The list that's generated should display a line for each monthly payment showing payment number, date due, payment amount, and donation balance (remaining amount of pledge owed). Assignment 2-10: Using a Basic Loop Accomplish the task in Assignment 2-9 by using a basic loop structure. Assignment 2-11: Using a WHILE Loop Accomplish the task in Assignment 2-9 by using a WHILE loop structure. Instead of displaying the donation balance (remaining amount of pledge owed) on each line of output, display the total paid to date. Assignment 2-12: Using a CASE Expression Donors can select one of three payment plans for a pledge indicated by the following codes: 0 = one-time (lump sum) payment, 1 = monthly payments over one year, and 2 = monthly payments over two years. A local business has agreed to pay matching amounts on pledge Hands-On Assignments Part II Assignment 2-9: Using a FOR Loop Create a PLISQL block using a FOR loop to generate a payment schedule for a donor's pledge, which is to be paid monthly in equal increments. Values available for the block are starting payment due date, monthly payment amount, and number of total monthly payments for the pledge. The list that's generated should display a line for each monthly payment showing payment number, date due, payment amount, and donation balance (remaining amount of pledge owed). Assignment 2-10: Using a Basic Loop Accomplish the task in Assignment 2-9 by using a basic loop structure. Assignment 2-11: Using a WHILE Loop Accomplish the task in Assignment 2-9 by using a WHILE loop structure. Instead of displaying the donation balance (remaining amount of pledge owed) on each line of output, display the total paid to date. Assignment 2-12: Using a CASE Expression Donors can select one of three payment plans for a pledge indicated by the following codes: 0 = one-time (lump sum) payment, 1 = monthly payments over one year, and 2 = monthly payments over two years. A local business has agreed to pay matching amounts on pledge