Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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 many students are enrolled in Section 2713 in the first semester of 2008? 4. List all the courses in alphabetical order by Course Name b. What is the output of the following two SQL queries SELECT FacultyID, CourseID, DateQualified FROM Qualified WHERE DateQualified >= '01-JAN-1993'; SELECT FacultyID, DateQualified FROM Qualified WHERE CourseID in SELECT CourseID FROM Course WHERE CourseName == 'Syst Design'); STUDENT (StudentID, StudentName) QUALIFIED (FacultyID, CourselD, DateQualified) StudentID StudentName FacultyID CourselD Date Qualified 2143 2143 38214 54907 66324 70542 Letersky Altvater Aiken Marra 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 3467 4756 4756 FACULTY (FacultyID, FacultyName) SECTION (Section No, Semester, CourselD) FacultyID Faculty Name 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 COURSE (CourselD, CourseName) REGISTRATION (StudentID, Section No, Semester) CourselD CourseName StudentID Section No Semester ISM 3113 ISM 3112 ISM 4212 ISM 4930 Syst Analysis Syst Design Database Networking 38214 54907 54907 66324 2714 2714 2715 2713 1-2008 1-2008 1-2008 1-2008

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 Modeling And Design

Authors: Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish

5th Edition

0123820200, 978-0123820204

More Books

Students also viewed these Databases questions