SP09-Apr16-Lec12-summary-MIS3100

SP09-Apr16-Lec12-summary-MIS3100 - = Offering.Courseno...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
MIS310-DUTTA- SPRING2009 Classnotes, Lecture 12, Apr16-2009 APPLICATION DEVELOPMENT WITH VIEWS SELECT FacSSN, FacLastName, FacFirstname, FacDept FROM Faculty SELECT FacSSN, OfferNo, Course.Courseno, CrsUnits, Offterm, Offyear, OffLocation FROM Offering, Course WHERE Course.CourseNo
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: = Offering.Courseno SELECT FacLastname, Facfirstname, sum(crsunits*Offnumenrolled) AS TOTSCH FROM Faculty, Offering, Course WHERE Faculty.FacSSN = Offering.FacSSN AND Offering.Courseno = Course.Courseno GROUP BY Faclastname, Facfirstname NORMALIZATION...
View Full Document

Page1 / 4

SP09-Apr16-Lec12-summary-MIS3100 - = Offering.Courseno...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online