Question: Write SQL queries to answer the following questions: a. Which students are enrolled in Database and Networking? (Use SectionNo for each class so you can

Write SQL queries to answer the following questions:

a. Which students are enrolled in Database and Networking? (Use SectionNo for each class so you can determine the answer from the Registration table by itself.)

b. Which instructors cannot teach both Syst Analysis and Syst Design?

c. Which courses were taught in the first semester of 2008 but not in the second semester of 2008?

The class scheduling 3NF relations along with some sample data shown in Figure 6-10. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.

STUDENT (StudentID, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentID StudentName FacultylD CourselD DateQualified 38214 Letersky Altvater 2143 ISM 3112 9/1988 54907 2143 ISM 3113 9/1988 66324 Aiken 3467 ISM 4212 9/1995 70542 Marra 3467 ISM 4930 9/1996 4756 ISM 3113 9/1991 4756 ISM 3112 9/1991 .. FACULTY (FacultyID, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultyID FacultyName SectionNo Semester CourselD 2143 Birkin 2712 1-2008 ISM 3113 3467 Berndt 2713 1-2008 ISM 3113 4756 Collins 2714 1-2008 ISM 4212 2715 1-2008 ISM 4930 .. COURSE (CourselD, CourseName) REGISTRATION (StudentID, SectionNo, Semester) CourselD CourseName StudentID SectionNo Semester ISM 3113 ISM 3112 Syst Analysis Syst Design Database Networking 38214 2714 2714 1-2008 1-2008 54907 54907 ISM 4212 2715 1-2008 ISM 4930 66324 2713 1-2008 FIGURE 6-10 Class scheduling relations (missing ASSIGNMENT)

Step by Step Solution

★★★★★

3.34 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a We assume all the question wishes in the result set are the Student IDs The Database course is ISM ... 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

Students Have Also Explored These Related Essentials Database Management Questions!

Write SQL queries to answer the following questions: a. Which students have an ID number that is less than 50000? b. What is the name of the faculty member whose ID is 4756? c. What is the smallest...

Write SQL queries to answer the following questions: a. How many students are enrolled in Section 2714 in the first semester of 2015? b. Which faculty members have qualified to teach a course since...

Use the diagram to answer the following questions (ad). a. At the equilibrium price before the tax is imposed, what area represents consumer surplus? What area represents producer surplus? b. Say...

8. Write SQL queries to answer the following questions: A) Which students are enrolled in both Database and Networking? (Hint: use SectionNo for each class, so that you can determine theanswer from...

Write SQL queries to answer the following questions: a. Which students are enrolled in Database and Networking? (Hint: Use SectionNo for each class so you can determine the answer from the...

. Write SQL queries to answer the following questions: a. Which students are enrolled in Database and Networking? (Hint: Use SectionNo for each class so you can determine the answer from the...

Write SQL queries to answer the following questions: What are the courses included in the Section table? List each course only once. List all students in alphabetical order by StudentName. List the...

This is a lab assignment that involves multiple tables in a database: Requirements: 1. Please write your SQL instructions for table creations and query answering into one executable file. 2. The file...

mysql questions. All questions are linked. Even if the pictures are blurry please help write the commands for the questions at least QUNSTION: Pandai Sdn Bhd is a company that runs a tuition center...

Madison Company has nine employees. FICA Social Security taxes are 6.2% of the first $106,800 paid to each employee, and FICA Medicare taxes are 1.45% of gross pay. FUTA taxes are 0.8% and SUTA taxes...

On January 1, 2020, Sheridan SpA had the following equity accounts. Share Capital-Ordinary (25 par value, 49,000 shares issued and outstanding) Share Premium-Ordinary Retained Earnings During the...

GMP requires compwies to use the allowance method bechuse it follows the mabching principle. Denpelleet Pepereioumai enties for each tremaction lithed. 3 . Adiation Entrifloe Bad.Dehts: At the end of...

Financial resources provided to health care during the COVID-19 pandemic were carefully calibrated to meet societal need. TRUE OR FALSE

Write down the bit pattern in the fraction assuming a floating point format that uses Binary Coded Decimal (base 10) numbers in the fraction instead of base 2. Assume there are 24 bits, and you do...

Write down the bit pattern assuming that we are using base 15 numbers in the fraction instead of base 2. (Base 16 numbers use the symbols 09 and AF. Base 15 numbers would use 09 and AE.) Assume there...

Write down the bit pattern assuming that we are using base 30 numbers in the fraction instead of base 2. (Base 16 numbers use the symbols 09 and AF. Base 30 numbers would use 09 and AT.) Assume there...

need help on the 3 wrong ones For the just completed year, Hanna Company had net income of $53,000. Balances in the company's current asset and current liability accounts at the beginning and end of...

Chesapeake Yachting Gear is analyzing a proposed project. The company expects to sell 6,000 units, plus or minus 3 percent. The expected variable cost per unit is $11 and the expected fixed costs are...

When the Australian government issues government bonds during a tender, the cumulative aggregate/total demand by bidders is the following: Yield Total cumulative aggregate demand (in AUD million face...