Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Number 5 please. What do I type in SQL so that I can get the result in number 5? Here are the tables: Problems and

Number 5 please. What do I type in SQL so that I can get the result in number 5?

image text in transcribed

Here are the tables:

image text in transcribed

Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some sample data in Figure 7-16D. For Problems and Exercises 1 through 5, draw a Venn or ER diagram and mark it to show the data you expect your query to use to produce the results. . Write SQL retrieval commands for each of the following queries: a. b. c. Display the course ID and course name for all courses with an ISM prefix. Display all courses for which Professor Berndt has been qualified. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212. 2. Write an SQL query to answer the following question: Which instructors are qualified to teach ISM 3113? 3. Write an SQL query to answer the following question: Is any instructor qualified to teach ISM 3113 and not qualified to teach ISM 4930? 4. Write SQL queries to answer the following questions: a. How many students were enrolled in section 2714 during semester -2008? b. How many students were enrolled in ISM 3113 during semester l-2008? 5. Write an SQL query to answer the following question: Which students were not enrolled in any courses during semester l-2008? Problems and Exercises 6 through 14 are based on Figure 7-17D. This problem set continues from Chapter 6, Problems and Exercises 10 through 15, which were based on Figure 6-12

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Database Concepts

Authors: David M. Kroenke, David J. Auer

7th edition

133544621, 133544626, 0-13-354462-1, 978-0133544626

More Books

Students also viewed these Databases questions

Question

1. Select the job or jobs to be analyzed.

Answered: 1 week ago