Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using a numeric loop that runs from the first student id = 105 to the last student id=150, select student first_name, last_name and also how

Using a numeric loop that runs from the first student id = 105 to the last student id=150, select student first_name, last_name and also how many sections the student is enrolled into. Maximum number of sections a student is allowed to enroll into is 5. If student enrolled in less then 5 (use here your IF statement), then calculate how many more additional sections the student can enroll into, and display a message in the following format: John Johansen is enrolled in 3 sections and is eligible for 2 more Carrie Drew is enrolled in 2 sections and is eligible for 3 more We had a program in class designed with FOR loop for STUDENT table, making a list of students in a numeric FOR loop. If you missed the class, please watch the recordings, Week 3 A, to get the idea of how to implement EXCEPTION block in inner begin-end block for the program not to break on a missing student in the list

Step by Step Solution

There are 3 Steps involved in it

Step: 1

You may accomplish this in SQL by iterating through the student IDs and gathering the necessary data ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems Analysis And Design

Authors: Alan Dennis, Barbara Wixom, Roberta M. Roth

7th Edition

1119496489, 978-1119496489

More Books

Students also viewed these Databases questions