View the step-by-step solution to:

# Thank you Using Conditional Controls and Looping (Lab 2 of 7): This iLab is due at the end of Week 2. Scenario/Summary:

Hi,

I am running behind with this assignment and need urgent assistance please.

Thank you

Using Conditional Controls and Looping (Lab 2 of 7):

This iLab is due at the end of Week 2.

Scenario/Summary:

You will be developing SQL PL procedures that demonstrate basic flow of control statements, such as conditionals (decisions) and looping (repetition).

Upon completion of this lab, students will have hands-on experience using flow of control constructs in SQL PL.

Deliverables:

Lab Steps (to be completed in Power Systems)

Points

Step 1 Make a new table 5 Pts.

Step 2 Populate the table with data 5 Pts.

Step 3 Make a procedure that uses conditional logic 15 Pts.

Step 4 Make a procedure that uses looping 15 Pts.

Step 5 Make a procedure that uses both conditional logic and looping 20 Pts.

Total Lab Points 60 Pts.

You should submit to the Dropbox a Word document containing:

•          SQL PL code for each task.

•          Screenshots of the output from each task (each screenshot immediately follows the associated code).

iLab Steps

Step 1: Make a New Table

A. Make a table called Branch using the following data definition parameters:

Attribute Data Type Size Restrictions

Branch Number Numeric Data 3 User-defined Primary Key

Branch Name  Alphanumeric Data 30

Branch Location Alphanumeric Data 20

Number of Employees Numeric Data 3

Step 2: Populate the Table with Data

a. Add the following data to your Branch table. Use the COMMIT statement when you are done. (This need not be done inside of a procedure - just adding the records in straight SQL is fine.)

Branch_no Branch_Name Branch_Location Num_ Emps

20 Evanston Library Evanston 45

30 Oak Brook Library Oak Brook 20

40 Darien Local Library Darien 15

50 Chicago Public Library Park View NULL

b. Use a SELECT statement to display the rows you have added.

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents
• ### -

Question & Answers

Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

Ask a Question