Write a query that ?nds all students who took MAT123 from Professor Ann White but did not take MAT321 from her.
What will be an ideal response?
We will use DRC. The TRC solution is similar.
```
{SN|? Id,Addr,Status,Sem,Gr,PId,Dept (
Student(Id,SN,Addr,Status) AND
Transcript(Id,’MAT123’,Sem,Gr) AND
Teaching(PId,’MAT123’,Sem) AND
Professor(PId,’Ann White’,Dept) AND
NOT ? Sem1,Gr1 (
Transcript(Id,’MAT321’,Sem1,Gr1) AND
Teaching(PId,’MAT321’,Sem1) )
)}
```
You might also like to view...
According to the Electronic Marketplace report of the Federal Trade Commission Fair Information Practices, which of the following is not one of the four privacy practices companies engaged in e-commerce should observe?
A. Notice/awareness B. Choice/consent C. Access/participation D. Availability/privacy
Which social media website should you use to create boards of images that link to webpages?
A. Facebook B. Instagram C. Pinterest D. LinkedIn