Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started