Question: 1. Write an SQL query to answer the following question: Which instructors are qualified to teach ISM 3113? 2. Write an SQL query to answer

1. Write an SQL query to answer the following question: Which instructors are qualified to teach ISM 3113?
2. Write an SQL query to answer the following question: Is any instructor qualified to teach ISM 3113 and not qualified to teach ISM 4930?
3. Write SQL queries to answer the following questions:
a. How many students were enrolled in section 2714 during semester I-2008?
b. How many students were enrolled in ISM 3113 during semester I-2008?

STUDENT (StudentiD, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentID FacultylD CourselD DateQualifie 38214 54907 66324 70542 2143 2143 3467 ISM 3112 ISM 3113 ISM 4212 ISM 4930 ISM 3113 ISM 3112 9/1988 9/1988 9/1995 9/1996 9/1991 9/1991 4756 4756 FACULTY (FacultylID, FacultyName) Facultycuyame SemestCourseID 2143 3467 4756 Birkin Berndt 2712 2713 2714 2715 I-2008 I-2008 I-2008 I-2008 ISM 3113 ISM 3113 ISM 4212 ISM 4930 COURSE (CourselD, CourseName) REGISTRATION (StudentiD, SectionNo, Semester) Coursel D StudentiD SectionNo ISM 31 ISM 3112 ISM 4212 ISM 4930 13 Syst Analysis 38214 54907 54907 66324 2714 2714 2715 2713 -2008 -2008 -2008 -2008 Syst Design Database

Step by Step Solution

★★★★★

3.40 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 SELECT Faculty Name FROM FACULTYQUALIFIED WHERE QUAL... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1019-B-C-A-C-P-A(1480).docx

120 KBs Word File

Students Have Also Explored These Related Cost Accounting Questions!

At Bird Company, an order is recorded in two separate tables as follows. The table titled orders contains a single record of header information for each order in the following fields: order number...

Use the following payoff matrix to answer the following questions. Suppose this is a one-shot game:a. Determine the dominant strategy for each player. If such strategies do not exist, explain why...

(1) The lessee compares the cost of owning the equipment with the cost of leasing it. Now put yourself in the lessors shoes. In a few sentences, how should you analyze the decision to write or not to...

Write an SQL query to answer the following question: Which instructors are qualified to teach ISM 3113?

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 Exercises 1 through 5 are based on the class schedule 3NF relations along with some...

Write an SQL query to answer the following question: 1. Which instructors are qualified to teach ISM 3113? 2. Write an SQL query to answer the following question: Is any instructor qualified to teach...

Write an SQL query to answer the following question: Is any instructor qualified to teach ISM 3113 and not qualified to teach ISM 4930? Write SQL queries to answer the following questions: a. How...

7-28 A. B. C. of that were introduced of the temp extensions Chapter 7 Advanced SQL 331 Discuss in ere to SQL 724. This chapter discusses the data dictionary views for as the temporal used 12e,...

- student(sid, sname, sex, age, year, gpa) [Year is a number between 1 and 5]. - dept( dname, numphds) - prof( pname, dname) - course(cno, cname, dname) [Course numbers are unique within...

1. Consider the following relational schemas, namely Employee, WorkOn, and Project. Employee ( eid , ename, age, supv_eid ) WorkOn ( eid , pid ) Project ( pid, pname, year ) The key fields are bold....

Fiona is 59 years old (she has reached her preservation age) and she is retired. On 1 July 2019, Fiona commenced a retirement phase income stream. The taxable component (taxed element) of her...

Of Cods original set of eight operators, union, difference, product, restrict, and project can be considered as primitives. Give definitions of natural join, intersect, and (harder) divide in terms...

Complete the workings to find the term-to-term rule and the next two terms of each sequence. 10 7,101, 14, 171, ... 1 7+3=10, 10 +... = 14, 14+... = 17 2 The term-to-term rule is: add The next two...

Suppose that you prefer reading a book you already own to watching TV and that you prefer watching TV to listening to music. If these are your only three choices, what is the opportunity cost of...

A population of honeybees increased at a rate of r(t) bees per week, where the graph of is as shown. Use Simpsons Rule with six subintervals to estimate the increase in the bee population during the...

(a) If f(x) = sin (sin x), use a graph to find an upper bound for | f (4) (x) |. (b) Use Simpsons Rule with n = 10 to approximate f(x) dx and use part (a) to estimate the error. (c) How large should...

Find the area of the region bounded by the hyperbola y2 x2 = 1 and the line y = 3.

- C www-awn.connectmath.com/alekscgi/x/Isl.exe/10_u-IgNslkr7j8P3jH-liJmDHM1JZm86qHOt4Z19FIBPzcbzAUPNAOLLcvA1bHH3eOWrpv5vq. 3 5 17 8 9 > Question 7 of 9 (5 points) | Attempt 1 of Unlimited View...

Assignment Questions: (Marks: 05) QI. NTL Company is issuing eight-year bonds with a coupon rate of 6.5 percent and semiannual coupon payments. If the current market rate for similar bonds is 8...

ErenCo is an up-and-coming stone quarry company. A recent report, reflecting the general sentiment of all market participants, projected the following prices and probabilities for ErenCo stock on...