Add a new column for the 2-digit contact code in the PUBLISHER table.
2. Add a foreign key constraint between your contacts table and PUBLISHER table.

 

Transcribed Image Text:

CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order# Item# ISBN Quantity Paideach BOOKS ISBN Title Pubdate PublD Cost Retail Discount Category BOOKAUTHOR AUTHOR AuthorD Lname Fname Gift Minretail Maxretail ISBN AuthorlD PUBLISHER PublD Name PROMOTION Contact Phone FIGURE 1-5 JustLee Books's table structures after normalization CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order# Item# ISBN Quantity Paideach BOOKS ISBN Title Pubdate PublD Cost Retail Discount Category BOOKAUTHOR AUTHOR AuthorD Lname Fname Gift Minretail Maxretail ISBN AuthorlD PUBLISHER PublD Name PROMOTION Contact Phone FIGURE 1-5 JustLee Books's table structures after normalization