Question
. Create the table that would result from a left outer join of PUBLISHER-join- BOOK. PUBLISHER (primary key: PUB_ID) PUB_ID PUB_NAME PUP_STATE A1 Shining Press
.Create the table that would result from a left outer join of PUBLISHER-join- BOOK.
PUBLISHER (primary key: PUB_ID)
| PUB_ID | PUB_NAME | PUP_STATE |
| A1 | Shining Press | NY |
| A2 | Wrinkled Publishing | NY |
| A2 | Matte Printing Co. | CA |
| A1 | Merchant Publishing | MD |
BOOK (primary key: BOOK_ID)
| BOOK_ID | BOOK_TITLE | BOOK_COST | PUB_ID |
| 500 | Sunny Days | 14.95 | A1 |
| 501 | Rainy Nights | 21.49 | A2 |
| 502 | Happy Mornings | 19.99 |
|
| 503 | Sultry Evenings | 25.95 | A1 |
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
Databases DeMYSTiFieD
Authors: Andy Oppel
2nd Edition
0071747990, 978-0071747998
