(Solved): Q: [sql] [oracle] C&…..
QUESTION Question [sql] [oracle] 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 …