Write a script that produces the following report:For each instructor, display one line with InstructorID, last name, first name, how many courses the instructor teaches, and a note that is defined as follows:“On leave”, when instructor teaches no courses,“Available for another course”, when instructor teaches only one course, andNothing otherwiseInstructors table contains data about instructors, and each course in the Courses table references InstructorID of an instructor who teaches the course.The structure of the script is totally up to you, as long as it displays the desired report.

Answered: Write a script that produces the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Write a script that produces the following report:

For each instructor, display one line with InstructorID, last name, first name, how many courses the instructor teaches, and a note that is defined as follows:

“On leave”, when instructor teaches no courses,
“Available for another course”, when instructor teaches only one course, and
Nothing otherwise

Instructors table contains data about instructors, and each course in the Courses table references InstructorID of an instructor who teaches the course.

The structure of the script is totally up to you, as long as it displays the desired report.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions