Databases Reference
In-Depth Information
Figure 8-11
PUBLISHER table
PUBNAME
CITY
COUNTRY
TELEPHONE
YRFOUND
AUTHOR table
AUTHORNUM
AUTHORNUM
YEARBORN
YEARDIED
BOOK table
BOOKNUM
BOOKNAME
PUBYEAR
PAGES
PUBNAME
CUSTOMER table
CUSTNUM
CUSTNAME
STREET
CITY
STATE
COUNTRY
WRITING table
BOOKNUM
AUTHORNUM
SALE table
BOOKNUM
CUSTNUM
DATE
PRICE
QUANTITY
Good Reading Bookstores tables.
7.
How do the table primary keys, indicated by a solid line under the
column name, relate to default table indexes?
8.
Several queries needed by regular operations depend on joining multiple
tables. How can you simplify these queries for your users?
