DBS501 – Just E-mail submission with Subject like : 501 Lab3 by Smith, John You need to provide BOTH — Code and Output Solved

$ 24.99
Category:

Description

1) Write a PL/SQL block that will display Descriptions (Full Names) of all Courses that do NOT need a Prerequisite in alphabetical order. Display also the total number of these courses. Use also an explicit cursor to solve this problem. Show all 4 phases when dealing with the cursor Here is the output:
Course Description : 1: DP Overview
Course Description : 2: Intro to Computers
Course Description : 3: Java for C/C++ Programmers
Course Description : 4: Operating Systems
************************************
Total # of Courses without the Prerequisite is: 4 PL/SQL procedure successfully completed.
2) Rewrite problem 1) by using an automated Cursor For Loop and INDEX BY Table to store Descriptions.
3) Write a PL/SQL block that will ask for an input of first 3 digits for a Zip Code and then will display number of students for each zip code. It will also calculate the total number of zip codes and total number of students for this 3 digit zip area. In the case that zip area is empty (NO students from there), it should display an appropriate message. You should use RECORD type with 2 components and Cursor with manual handling (all 4 phases). Here are the possible outputs:
073
Zip code : 07302 has exactly 1 students enrolled.
Zip code : 07304 has exactly 2 students enrolled.
Zip code : 07306 has exactly 4 students enrolled.
Zip code : 07307 has exactly 3 students enrolled.
************************************ Total # of zip codes under 073 is 4
Total # of Students under zip code 073 is 10 PL/SQL procedure successfully completed.
013
This zip area is student empty. Please, try again. PL/SQL procedure successfully completed.
4) Rewrite problem 3) by using an automated Cursor For Loop and INDEX BY Table instead of RECORD type.

Reviews

There are no reviews yet.

Be the first to review “DBS501 – Just E-mail submission with Subject like : 501 Lab3 by Smith, John You need to provide BOTH — Code and Output Solved”

Your email address will not be published. Required fields are marked *