Answer number 9 please
1. Create two tables containing data with at least 4 columns and 4 rows of data each so that the tables clearly are not union- compatible. You cannot use one of the examples from class or the book- create your own 2. Create two tables containing data with at least 4 columns and 4 rows of data each that are union-compatible. Be sure that at least one row (but not all rows) in the first table is identical to a row in the second table. You cannot use one of the examples from class or the book- create your own. Use these two tables to illustrate the Union relational operator, then the Difference relational operator For the remaining 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. The primary keys are indicated below AUTHOR (primary key: AU ID AU ID AU LNAME AU FNAME 102 103 104 Peterson Sullivan Patel Huan Cliff Rich Kumar Wen WRITES (composite primary key: AU ID, BOOK ID) AU ID BOOK ID 101 103 101 105 103 104 500 500 501 501 502 502 BOOK (primary key: BOOK ID BOOK ID BOOK TITLE 500 501 502 503 Sunny Days Rainy Nights Happy Mornin Sultry Evenings25.95 BOOK COST PUB ID 14.95 21.49 19.99 A l A1 PUBLISHER (primary key: PUB ID PUB ID PUB NAME Al A2 A2 PUB STATE NY Shining Press Wrinkled Publishing NY Matte Printing Co Merchant Publishing MD CA Does the AUTHOR table have entity integrity? Why or why not? Does the WRITES table have entity integrity? Why or why not? Does the WRITES table have referential integrity in its relationship with AUTHOR? Why or why not? Does the BOOK table have referential integrity in its relationship with PUBLISHER? Why or why not? Does the BOOK table have referential integrity in its relationship with WRITES? Why or why not? Create the table that would result from a Natural Join of BOOK-join-PUBLISHER. Create the table that would result from an Equijoin of PUBLISHER-join-BOOK Create the table that would result from a Left Outer Join of PUBLISHER-join-BOOK
