This document was uploaded by user and they confirmed that they have the permission to share
it. If you are author or own the copyright of this book, please report to us by using this DMCA
report form. Report DMCA
Overview
Download & View A3-askisi1-mandrakis as PDF for free.
Book(isbn, title, p_id) Publisher (p_id, name, address, telephone) Author(s_id, name) Writes(isbn, s_id) 1. SELECT * FROM author a; 2. SELECT s_id FROM author a WHERE name like "A%"; 3. SELECT b.isbn,b.title,p.name,p.address,p.telephone FROM book b, publisher p WHERE b.p_id=p.p_id;