Question

Assignment 5 - Query the University Enrollment Database (Hard copy due: in class Monday, 11/11/2019. 4pts/query) Your Goal: Use the database you have created in the SQL Server and finish the following queries. Student 9 Std No Std First Name StdLast Name Std Major StdClass StdZip Enrollment Offerno StdNo GradePoint Offering Offer No CourseNo OffTerm Off Year OffLocation OH Time FacNo OfDays Course 9 CourseNo CrsDesc CrUnits Ziptable ZipCode City State Faculty FacNo FacFirst Name FacLast Name FacDept FacRank FacSalary FacSupervisor FacHireDate FacZip Query #1: Your manager wants to know who is enrolled with each department. Show student number and the enrolled department name. Sort your results by department name. Partial results are shown as a demo: Std No 124567890 234567890 345678901 FacDept BIS BIS BIS

Answer 1

Please find the SQL query below.

QUERY

SELECT s.StdNo, f.FacDept from Student s, Enrollment e, Offering o, Faculty f where s.StdNo = e.StdNo and e.OfferNo = o.OfferNo and o.FacNo = f.FacNo ORDER BY f.FacDep;