Find all students (StudIds) who had taken a course from each professor in the MUS department.

Write the query of Exercise 5.20 using TRC and DRC.

One way to write this query is to ?rst de?ne a view, MUSprof, which contains all tuples from Professor that correspond to Musics Department. Then we could use the quanti?er ?P ? MUSprof to express this query similarly to the use of the view CSProf at the end of Section 13.1. The solution below uses the implication instead of the view.


a. TRC:


{S.StudId | Student(S) AND
?P ? Professor(P.Dept= ’MUS’ ?
?R ? Transcript ?T ? Teaching
(S.Id = R.StudId AND P.Id = T.ProfId AND
T.CrsCode = R.CrsCode AND T.Semester = R.Semester )) }


DRC:

{StudId |?Name?Addr?Status Student(StudId, Name, Addr, Status) AND
?ProfId?ProfName(Professor(ProfId, ProfName, ’MUS’) ?
?CrsCode?Sem?Grade(Transcript(StudId, CrsCode, Sem, Grade)
AND Teaching(ProfId, CrsCode, Sem))) }

Computer Science & Information Technology

You might also like to view...

A ________ is a form that contains a Navigation Control

A) stacked layout B) Single Form C) Navigation Form D) tabular layout

Computer Science & Information Technology

Why should you include captions with your graphics?

A) So that the reader can understand clearly why the graphic was included B) Because Word requires captions in order to know what the graphic inserted is C) In order to help the hearing impaired D) To aid in file conversion to other file formats

Computer Science & Information Technology

Frame-by-frame animations are also known as ________________ animations.

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

Computer Science & Information Technology

What are the four types of variables you can assign to a parameter in the Animation State Machine?

What will be an ideal response?

Computer Science & Information Technology