Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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? image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Modeling And Design

Authors: Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish

5th Edition

0123820200, 978-0123820204

More Books

Students also viewed these Databases questions