Question: I need help please. Can you answer and explain the questions? Use the following tables that depict that an author can write many books, and
I need help please. Can you answer and explain the questions?
Use the following tables that depict that an author can write many books, and a book can have many authors. Each book has only one
publisher, but a publisher can publish many books. An author can attend many book signings. Each book signing is done by only one
author. The primary keys to consider are indicated.
SIGNING primary key: SIGN ID
WRITES composite primary key: AUID BOOKID
AUTHOR primary key: AUID
BOOK primary key: BOOKID
PUBLISHER primary key: PUB ID
Does the PUBLISHER table have entity integrity? Why or why not?
Does the AUTHOR table have entity integrity? Why or why not?
Does the WRITES table have entity integrity? Why or why not?
Does the SIGNING table have referential integrity in its relationship with AUTHOR? Why or why not?
Does the PUBLISHER table have referential integrity in its relationship with BOOK? Why or why not?
Does the WRITES table have referential integrity in its relationship with BOOK? Why or why not?
Create the table that would result from an Equijoin of SIGNINGjoinAUTHOR.
Create the table that would result from a RIGHT Outer Join of BOOKjoinPUBLISHER.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
