Express the following queries in relational algebra.

a. (5.16)
b. (5.20)
c. (5.23)


a. ```
?Name(?DeptId='CS' OR DeptId= 'EE' (Professor))
```

b. ```
?Name(?CrsCode='CS305' AND CrsCode2= 'CS315' (BigJoin)
```

where BigJoin is de?ned as:
```
Student Id=StudId Transcript  Transcript[StudId,CrsCode2,S2,G2]
```

Observe that a careful renaming of the attributes has allowed us to use the natural join between the two occurrences of Transcript and to make the expression shorter.

c. ```
?Id(Student) ? ?StudId(Transcript)
```

Computer Science & Information Technology

You might also like to view...

The Shapes gallery displays when the Crop button is clicked

Indicate whether the statement is true or false

Computer Science & Information Technology

DTEs receiving frames with the __________ bits set try to reduce the flow of frames until con gestion clears

a. DE b. CIR c. CBIR d. BECN

Computer Science & Information Technology

Unless you specify otherwise, a linear gradient starts at the __________ of an element.

A. top B. right C. bottom D. left

Computer Science & Information Technology

Of the last 71 people who went to the cash register at Wal-Mart 10 had blond hair, 19 had black hair, 34 had brown hair, and 8 had red hair. Determine the empirical probability that the next person to come to the cash register will have red hair.

A. 27% B. 48% C. 89% D. 14% E. 11%

Computer Science & Information Technology