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) )
)}
```

Computer Science & Information Technology

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

Computer Science & Information Technology

Which social media website should you use to create boards of images that link to webpages?

A. Facebook B. Instagram C. Pinterest D. LinkedIn

Computer Science & Information Technology