The primary key for the customers table is The primary key for the orders table is The primary key for the books table is The primary key for the author table is and the foreign key is and the foreign key is What two columns in orderitems table are not a part of the primary key or foreign key? What two columns in the author table are not a part of the primary key? and and 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 Author D Lname Fname Gift Minretail Maxretail ISBN AuthorlD PUBLISHER PublD Name PROMOTION Contact Phone FIGURE 1-5 JustLee Books's table structures after normalization