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

ID: 672464 • Letter: C

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.

4.Provide the SSN of those authors who have coauthored at least one book with the author named Andy Smith.

dom(name)=name dom(SSN)=SSN

dom(phone)=phone dom(first_name)=first_name

dom(address)=address dom(last_name)=last_name

dom(address)=address

dom(income)=income

CREATE VIEW SSN AUTHORS

AS SELECT AUTHOR NAME ='Andy sMITH' FROM AUTHOR

WHERE COAUTHOR =1

WHERE