Question: 1-Consider the below database schema: Professor(ssn, profname, status) Course(crscode, crsname, credits) Taught(crscode, semester, ssn) Query1) Return the ssn of professors who have taught COMP440. ssn

1-Consider the below database schema:

Professor(ssn, profname, status)

Course(crscode, crsname, credits)

Taught(crscode, semester, ssn)

Query1) Return the ssn of professors who have taught COMP440.

 1-Consider the below database schema: Professor(ssn, profname, status) Course(crscode, crsname, credits) ssn Taught(crscode, semester, ssn) Query1) Return the ssn of professors who have taught t.crscode ='COMP440' ( Professor * ( COMP440. ssn t.crscode ='COMP440' ( Professor * ( crscode t.crscode=c.crscode) Query2) Return crscode the ssn of professors who have taught COMP440 in Spring 2020 semester. t.crscode=c.crscode)

Query2) Return the ssn of professors who have taught COMP440 in Spring 2020 semester.

ssn t.crscode ='COMP440' ( Professor * ( crscode t.crscode=c.crscode) Query3) Return the ssn ssn of professors who have taught both COMP440 and COMP541. ssn t.crscode t.crscode ='COMP440' ( Professor * ( ='COMP440' & COMP541 ( Professor * ( crscode t.crscode=c.crscode) Query4) Return the crscode codes of courses that have never been taught. crscode (crscode = Course t.crscode=c.crscode)

Query3) Return the ssn of professors who have taught both COMP440 and COMP541.

(Taught)) Query5) Return the names of courses that have never been taught. ssn crsname (crscode = Course (Taught)) Query6) Return the names of professors who t.crscode ='COMP440' & COMP541 ( Professor * ( ever taught COMP440. profname t.crscode = COMP440 ARE THESE CORRECT ?? crscode image text in transcribed t.crscode=c.crscode)

Query4) Return the codes of courses that have never been taught.

image text in transcribed crscode (image text in transcribedcrscode = Course (Taught))

Query5) Return the names of courses that have never been taught.

image text in transcribed crsname (image text in transcribedcrscode = Course (Taught))

Query6) Return the names of professors who ever taught COMP440.

image text in transcribed profname image text in transcribed t.crscode = COMP440

ARE THESE CORRECT ??

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!