Write SQL query (5.10), and query (5.11), using TRC and DRC.

What will be an ideal response?


Find all courses taught in fall 1995 together with the professors who taught those courses.
a. TRC:


{C.Name, P.Name | Course(C) AND Professor(P) AND
?T ? Teaching (T.Semester= ’F1995’ AND
T.CrsCode= C.CrsCode AND T.ProfId= P.Id)) }


b. DRC:

{CName, PName |?CDept?CrsCode?PId?PDept
(Course(CDept,CrsCode,CName)
AND Professor(PId,PName,PDept)
AND Teaching(PId,CrsCode,’F1995’)) }

Computer Science & Information Technology

You might also like to view...

Any PowerPoint presentation can be given to audiences as a(n) ________ to accompany a lecture

Fill in the blank(s) with correct word

Computer Science & Information Technology

You use the ____________________ command to remove rows from a table.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Molly, an end user, connects an external monitor, external keyboard and mouse, and a wired network cable to her laptop while working in the office. She leaves the office frequently to meet with customers and takes the laptop with her. Disconnecting and reconnecting these external connections has become inconvenient.   Which of the following devices will allow the user to disconnect and reconnect the laptop to the external connections with the least amount of effort? (Select TWO).

A. USB to RJ-45 dongle B. Expansion card C. ZIF connector D. Port replicator E. Docking station

Computer Science & Information Technology

Explain in detail what a slice is, how it is used, and how it is created.

What will be an ideal response?

Computer Science & Information Technology