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 Sumaya University for Technology King Talal School of Business Technology Department of Business Information Technology ..Write SQL query to answer the following questions 1. Which faculty members have an ID number prater than 25007 2. What is the largest section number used in the first semester of 2008? How many students are enrolled in Section 2713 in the first semester of 2008 4 Lis all the courses in alphabetical onder by Course Name 1. What is the output of the following to SQL queries? SELECT FacultyID. CourselD, Dutcwalified FROM Qualified WHERE Dateulified >= 01-JAN-1993; SELECT Faculty ID Dateualified FROM Qualified WHERE Coursel in SELECT Course FROM Course WHERE CourseName Syst Designs Given the relations below, answer the following questions: STUDENT (StudentID, StudentName) QUALIFIED (FacultyID, CourselD, DateQualified) Studenti Faculty Coursel Date Qualified 38214 54907 66324 70542 StudentName Letersky Altvater Alken Marra 2143 2143 3467 3467 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 4756 FACULTY (Faculty, FacultyName) SECTION (SectionNo, Semester, CourselD) Faculty Faculty Name Section No Semester Coursel 2143 3467 Birkin Berndt Collins 2712 2713 4756 2714 1-2008 1-2008 1-2008 1-2008 ISM 3113 ISM 3113 ISM 4212 ISM 4930 2715 COURSE (CourselD, CourseName) REGISTRATION (Studenti, SectionNo, Semester) Courtel Studenti Section No ISM 3113 ISM 3112 ISM 4212 ISM 4930 CourseName Syst Analysis Syst Design Database Networking 38214 54907 54907 66324 2714 2714 2715 2713 Semester 1-2008 1-2008 1-2008 1-2008 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 Courseld in SELECT CourseID FROM Course WHERE CourseName 'Syst Design')