Question: 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 the SQL queries for the following questions and show results.

QUALIFIED (FacultyID, CourselD, Date Qualified) STUDENT (StudentID, StudentName) FacultyID CourselD Date Qualified Student ID 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-2008 1-2008 1-2008 ISM 3113 ISM 3113 ISM 4212 ISM 4930 REGISTRATION (Studenti, Section No, 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 64007 68324 2714 2714 2715 2713 |-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 SQL queries for the following: QUALIFIED (FacultyID, CourselD, Date Qualified) STUDENT (StudentID, StudentName) FacultyID Courseld Date Qualified StudentID StudentName 38214 54907 66324 70542...

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

What would be the code to erase student Lopez from the table (you can type it here in Word)? What would be the code to show the students who have a 2 in their StudentID (you can type it here in...

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

Database management for business Given the relations below. answer the following questions STUDENTS QUARED 21 SMS w SCOOT A FACULTY C 114 21 0 200 COURSE REGISTRATION Care MIS ESH MED 90 Princess...

a. Write SQL query to answer the following questions. 1. Which faculty members have an ID number greater than 2500? 2. What is the largest section number used in the first semester of 2008? 3. How...

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

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 2008? b. Which faculty members have qualified to teach a course since...

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

1. Write the definition of a void function that takes as input a decimal number and as output 3 times the value of the decimal number. Format your output to two decimal places. 2. Write the...

Based on the case below, what decision should Adamolekun make? Should he invest aggressively in both dine-in and To Go, invest aggressively in one business and moderately in another, or invest...

As a general consumer of financial information, what type of analysis are you most likely to encounter in the media?

University of Arkansas Econ 4333: Economics of Organization: Online Case Study 2: Directions The summer months bring warm weather, mega fauna (bears), and tourists to the coastal towns of Alaska....