homework1

Homework1 - From STUDENT S COURSE C REIGISTERED R SECTION E Where S.StudentID= R.StudentID AND R.SectionID= E.SectionID AND E.CourseID= C.CourseID

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
1. Select FacultyID From QUALIFIED Where CourseID=’ISM6216’ AND FacultyID not in ( Select distinct FacultyID From QUALIFIED Where CourseID=’ISM6220’); 2. Select Q2.FacultyID From QUALIFIED Q1, QUALIFIED Q2 Where Q1.CourseID=’ISM6216’ AND Q1.FacultyID=Q2.FacultyID AND Q2.CourseID=’ISM6423’; 3. Select StudentName, CourseName
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: From STUDENT S, COURSE C, REIGISTERED R, SECTION E Where S.StudentID= R.StudentID AND R.SectionID= E.SectionID AND E.CourseID= C.CourseID Group by StudentName, CourseName; 4. Select FacultyID From FACULTY Where FacultyID not in ( Select distinct FacultyID From QUALIFIED);...
View Full Document

This note was uploaded on 09/07/2011 for the course ECON 101 taught by Professor Peter during the Spring '11 term at UFV.

Ask a homework question - tutors are online