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))) }
You might also like to view...
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
A ________ is a form that contains a Navigation Control
A) stacked layout B) Single Form C) Navigation Form D) tabular layout
Frame-by-frame animations are also known as ________________ animations.
Fill in the blank(s) with the appropriate word(s).
What are the four types of variables you can assign to a parameter in the Animation State Machine?
What will be an ideal response?