Question: Can you check if the work is correct or not? For the remaining questions, use the following tables that depict that an author can write

Can you check if the work is correct or not?  Can you check if the work is correct or not? For

For the remaining questions, use the following tables that depict that an author can write many books, and a authors. Each book has only one publisher, but a publisher can publish many books. The primary keys are AUTHOR (primary key: AU ID) AU IDAU LNAME AU FNAME 101 PetersonCliff 102 103 104 Sullivan Patel Huang Rich Kumar Wen WRITES (composite primary key: AU ID, BOOK ID) 101 103 101 105 103 104 OOK ID 500 500 501 501 502 502 BOOK (primary key: BOOK ID) BOOK ID BOOK TITLE BOOK COST PUB ID 500 501 502 503 Al A2 14.95 Rainy Nights Happy Mornings 19.99 Sultry Evenings 25.95 Al PUBLISHER (primary key: PUB ID PUB IDPUB NAME PUB STATE NY Al A2 A2 Shining Press Wrinkled Publishing NY Matte Printing Co. CA A3 Merchant Publishing MD 3. Does the BOOK table have entity integrity? Why or why not? . Does the PUBLISHER table have entity integrity? Why or why not? 5. Does the WRITES table have referential integrity in its relationship with AUTHOR? Why or wl 6. Does the WRITES table have referential integrity in its relationship with BOOK? Why or why t 7. Does the AUTHOR table have referential integrity in its relationship with WRITES? Why or wi 8. Create the table that would result from a Natural Join of PUBLISHER-join-BOOK. Create the table that would result from an Equijoin of PUBLISHER-join-BOOK. 10. Create the table that would result from a Right Outer Join of WRITES-join-AUTHOR

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!