Form the projection (Teaching assignments) [course, instructor] Teaching Assignm

Question

Form the projection (Teaching assignments) [course, instructor] Teaching Assignments

Course                  Section         Semester             Instructor
MAT 241                   1               Fall                    Gossett
MAT 241                   2               Fall                    Gossett
MAT 222                   1               Winter                Kinney
MAT124M                 1              Fall                     Conrath
MAT124M                 2               Fall                    Kinney

A.) course: MAT 241, MAT 241, MAT 222, MAT124M, MAT124M; instructor: Gossett, Gossett, Kinnery, Conrath, Kinney

B.) course: MAT 241, MAT 222, MAT124M; instructor: Gossett, Kinnery, Conrath

C.) course: MAT 241, MAT 222, MAT124M, MAT124M; instructor: Gossett, Kinnery, Conrath, Kinney

Explanation / Answer

Ans A - CREATE PROJECTION Teaching_assignments(course, instructor) AS SELECT COURSE, INSTRUCTOR FROM Teaching_Assignments

Ans B - CREATE PROJECTION Teaching_assignments(course, instructor) AS SELECT DISTINCT COURSE, INSTRUCTOR FROM Teaching_Assignments

Ans C - CREATE PROJECTION Teaching_assignments(course, instructor) AS SELECT COURSE, INSTRUCTOR FROM Teaching_Assignments WHERE ROWNUM<>1

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects