6. Formulate a SQL query in SQL View to list the first and last names of the fac

Question

6. Formulate a SQL query in SQL View to list the first and last names of the faculty who taught IS320 class, along with offer term, year and days.

7. Formulate a SQL query in SQL View to list the course numbers of IS courses taught by Assistant Professors, along with the faculty name, offer term, year and days.

Student Relationships Offering Coursel s Student Course Enrollment stdNo stdFirstName . stdlastName CrsDesc CrsUnits stdNo EnrGrade stdCity stdState stdžip Offering OfferNo CourseNc offterm Offfear OffLocation Offtime FacNo OffDays Faculty 1 Faculty FacFirstName FaclastName FacCity FacState FaczipCode FacRank FacHireDate FacSalary FacFirstName FacLastName FacCity FacState FacZipCode FacRank FacHireDate FacSalary FacSupervisor FacDept FacSupetrvisor äcDept

Explanation / Answer

Question 6

select FactFirstName,FactLastName,OffTerm,OffYear,OffDays from Faculty,Offering where Faculty.FacNo=Offering.FacNo and CourseNo="IS320";

Question 7

select CourseNo,FactFirstName,FactLastName,OffTerm,OffYear,OffDays from Faculty,Offering where Faculty.FacNo=Offering.FacNo and CourseNo="%IS%" and FacRank="Assistant Professor";

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.