Question: Write SQL queries for the following: QUALIFIED (FacultyID, CourselD, Date Qualified) STUDENT (StudentID, StudentName) FacultyID Courseld Date Qualified StudentID StudentName 38214 54907 66324 70542 Letersky

Write SQL queries for the following:

QUALIFIED (FacultyID, CourselD, Date Qualified) STUDENT (StudentID, StudentName) FacultyID Courseld Date Qualified StudentID StudentName 38214 54907 66324 70542 Letersky Altvater Aiken Marra 2143 2143 3467 3467 4756 4756 ISM 3112 ISM 3113 ISM 4212 ISM 4930 ISM 3113 ISM 3112 9/1988 9/1988 9/1995 9/1996 9/1991 9/1991 FACULTY (FacultyID, FacultyName) SECTION (SectionNo Semester, CourselD FacultyID FacultyName Section No Semester CourselD 2143 3467 4756 Birkin Berndt Collins 2712 2713 2714 2715 1-2008 1-2000 1-2008 1-2008 ISM 3113 ISM 3113 ISM 4212 ISM 4930 REGISTRATION (Studenti, SectionNo, Semester) COURSE (Courseld, CourseName) Studenti Section No Semester CourseID CourseName ISM 3113 ISM 3112 ISM 4212 ISM 4930 Syst Analysis Syst Design Database Networking 38214 54907 84007 66324 2714 2714 2715 2713 1-2008 1-2008 -2008 -2008 List all the section numbers of course 'Syst Analysis'. . List, in alphabetical order, the names of those students who have been enrolled in ISM class. . How many faculty members were qualified to teach 'ISM 3112' before 1990? - How many students are enrolled in each section (hint: use group by)? - List the names of the courses that Altvater has registered

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 General Management Questions!

Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types:...

Because of referential integrity, before any row can be entered into the SECTION table, the CourseID to be entered must already exist in the COURSE table. Write an SQL assertion that will enforce...

I5. Write the SQL commands for creating each of the relations shown below. Specify the primary key(s) and foreign key(s) (if necessary) constrains for each relation in the commands. (9%) Assume the...

MAX 506: Fundamentals of Database Management Systems Assignments 6 Dr. Dinakar Jayarajan Total Points: 70 Submit t your work in a single PDF file. Make sure to properly refer to the question numbers...

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

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 the SQL queries for the following questions and show results. QUALIFIED (FacultyID, CourselD, Date Qualified) STUDENT (StudentID, StudentName) FacultyID CourselD Date Qualified Student ID...

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...

STUDENT (StudentID, StudentName) QUALIFIED (FacultyID, CourselD, DateQualified) StudentID StudentName FacultyID CourselD Date Qualified 38214 54907 66324 70542 Letersky Altvater Aiken Marra 2143 2143...

Assignment No: 04 SQL Commands Task No.1: Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version)....

Use the Tax Rate Schedules to determine tax liability for each of the cases in problems 43, 44, and 45, above.

In our analysis of the wumpus world, we used the fact that each square contains a pit with probability 0.2, independently of the contents of the other squares. Suppose instead that exactly N/5 pits...

13. At the end of the year, Falabella Co. has pretax financial income of $550,000. Included in the $550,000 is $70,000 interest income on governmental bonds, a $25,000 fine for dumping hazardous...

The following companies are competing in the market: Company A has 75,000 units sold and revenues of $685,000. It has 9,000 customers while serving a market size of 80,000. Company B has 3,000 units...