Find the names of faculty who have taught every course that


Consider the relational database shown below:
Faculty(Id, Name, OfficeNo, OfficePh)
Course(Cno,CName,NoOfCredits)
Section(SecNo,Cno,Year,Term)
Teaches(FacultyId, SecNo)

a) Find all the sections associated with the course "CSSE123". Give an expression in relational algebra and domain relational calculus

b) Find the names of faculty who have taught every course that is being taught by John Nick in Spring 2010. Give an expression in Relational alegebra and domain relational calculus.

 

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Find the names of faculty who have taught every course that
Reference No:- TGS0645831

Expected delivery within 24 Hours