Write the query that ?nds all students who took some course from Professor Joe Public; use TRC and DRC.
What will be an ideal response?
TRC:
```
{ S.Name | Student(S) AND Transcript(R) AND
Teaching(T) AND Professor(P) AND
S.Id = R.StudId AND R.CrsCode = T.CrsCode AND
R.Semester = T.Semester AND T.ProfId = P.ProfId AND
P.Name = ’Joe Public’ }
```
DRC:
```
{SN|? Id,Addr,Status,CrsCode,Sem,Gr,PId,Dept (
Student(Id,SN,Addr,Status) AND
Transcript(Id,CrsCode,Sem,Gr) AND
Teaching(PId,CrsCode,Sem) AND
Professor(PId,’Joe Public’,Dept) ) }
```
You might also like to view...
Answer the following statements true (T) or false (F)
1) C# is like C++ in that programmers must manage memory explicitly. 2) A destructor has the same name as the class and its constructor. 3) You cannot determine when the garbage collector will execute. 4) The garbage collector looks for objects with no values. 5) Each object of a class has its own copy of all the instance variables of the class.
What changes does FTP make to an ASCII file when you download it in ASCII mode to a Windows machine from a Linux server? What changes are made when you download the file to a Mac?
What will be an ideal response?
The ________ button allows you to add additional options to the Quick Access Toolbar
A) More B) Arrow C) General D) Customize
A method defined with keyword void
a) must specify a return type b) does not accept arguments c) returns a value d) does not return a value