Consider the following schema: Publisher (name, phone, city), PK: name. Book (ISBN, title, year, published_by, previous_edition, price), PK: ISBN, FK: published_by refs Publisher, previous_edition refs Book.
oracle SQL
Consider the following schema:
Publisher (name, phone, city), PK: name.
Book (ISBN, title, year, published_by, previous_edition, price), 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.
Editor (SSN, first_name, last_name, address, salary, works_for, book_count), PK: SSN, FK: works_for refs Publisher.
Edit (eSSN, bISBN), PK: (eSSN, bISBN), FK: eSSN refs Editor, bISBN refs Book.
Author_Editor (aeSSN, hours), PK: aeSSN, FK: aeSSN refs Author, aeSSN refs Editor.
Please be advised that answers such as SELECT title from Book WHERE ISBN IN (SELECT aSSN from Write WHERE COUNT(aSSN)>3) will work as
the question refers to books that have more than 3 authors, meaning 3 or more authors worked on the same book. so not aSSN so it would need to be something like bISN>3
Give the title of those books that have more than 3 authors. (you will need bISN count not aSSN count as it is asking for a book with more than 3 authors)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
