CS2102 person pid, nama) readipid, istn bock/isbn bitle) Question 14. 4 marks) (
ID: 3756272 • Letter: C
Question
CS2102 person pid, nama) readipid, istn bock/isbn bitle) Question 14. 4 marks) (SQL) Find the name of the caerent persons who read al the bookes with the word Singapora" in the title. Use ggregetes. Assume that there is at least one book with the word "Singapone" in the icle Question 15. (4 marka) (SQL) Find the pid of the different persons who read all the booics with the word Singapore" in the title. Use NOT EXISTS CS2102 Question 16. (5 marka) (TRC) Find the pid of the aferent persons who read ll he books with the tile Singapora'Explanation / Answer
/*If you have any query do comment in the comment section else like the solution*/
select distinct(name) from person as p, read as r, book as b where p.pid=r.pid and r.isbn=b.isbn and b.title='Singapore';
select distinct(pid) from person as p, read as r, book as b where p.pid=r.pid and r.isbn=b.isbn and b.title='Singapore';
TRC={P | person(P) and p.pid=read.pid and book.isbn=read.isbn and book.title='Singapore'}