1.Customer(cid,Fname,Lname,rank),
2.Author(aid,Fname,Lname,Address);
3.Book(bid,title,subject,aid,quantity-in-stock);
4.Rental(cid,bid,quantity,start_date,return_date).
(a)Findalldistinctbooktitlesoftheauthorwhoselastnameis“LeeHom”
(b)Findallcustomerswhohaveborrowedatleastthreebooksfromthebookstore.
(c)Findallauthorswhohavewrotebooksinatleasttwosubjects.
(d)Findalldistinctbooktitlesofthecustomerwhoserankislargethan5andhavemorethan3booksinquantity.
|