Consider the following schema: Publisher (name, phone, address), PK: name. Book

Question

Consider the following schema:

Publisher (name, phone, address), PK: name.

Book (ISBN, title, year, published_by, previous_edition), PK: ISBN, FK: published_by refs Publisher, previous_edition refs Book.

Author (SSN, first_name, last_name, address, income), PK: SSN.

Write(aSSN, bISBN), PK: (aSSN, bISBN), FK: aSSN refs Author, bISBN refs Book.

Author_Editor(aeSSN, works_for), PK: aeSSN, FK: aeSSN refs Author, works_for refs Publisher.

Give relational algebraic expressions or SQL statements for the following plain English language queries based on the above schema.

1.Provide the first name and last name of author-editors and the name and phone of the publishers that they work for.

Explanation / Answer

select auth.first_name, auth.last_name,pub.name,pub.phone
from Author auth,Author_Editor authe,Publisher pub
where authe.aeSSN=auth.SSN and works_for.authe=pub.name;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.