Showing Page:
1/2
a. How many students were enrolled in section 2714
during
semester I-2008?
b. How many students were enrolled in ISM 3113 during
semester I-2008? STUDENT (StudentiD, StudentName)
QUALIFIED (FacultylD, CourselD, DateQualified StudentID
FacultylDCourselD 38214 54907 FACULTY (FacultylD,
FacultyName) FacultylD 2143 4756 SemestCourseID I -2008
I-2008 I-2008 I-2008 ISM 3113 ISM 3113 ISM 4212
COURSE (CourselD, CourseName) REGISTRATION
(StudentID, SectionNo, Semester) StudentiD SectionNo
ISM 31 ISM 3112 ISM 4212 ISM 4930 13 Syst Analysis 12
Syst Design -2008 -2008 -2008 -2008 38214 2 Database
Solution
a) SELECT COUNT (DISTINCT (StudentID)) FROM
REGISTRATION WHERE SectionNo = 2714
AND SEMESTER = \'I-2008\'
b) SELECT COUNT (DISTINCT (StudentID)) FROM
SECTION, REGISTRATION WHERE SECTION.SectionNO =
REGISTRATION.SectionNO AND CourseID = \'ISM 3113\'
AND Semester = \'I-2008\'
Showing Page:
2/2

Unformatted Attachment Preview

Name: Description: ...
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4