ORDERS CUSTOMERS Order# Customer# Customer# Orderdate Lastn...

ORDERS CUSTOMERS Order# Customer# Customer# Orderdate Lastname Shipdate Firstname Shipstreet Email Address Shipcity Shipstate City State Shipzip BOOKAUTHOR AUTHOR Zip Shipcost BOOKS ISBN AuthorlD Referred ISBN AuthorID Region ORDERITEMS Lname Title Order# Pubdate Item# PublD Fname ISBN Cost Quantity Retail Paideach Discount Category PUBLISHER PublD Name PROMOTION Contact Phone Gift Minretail Maxretail

Thanks for your feedback!

Texts: So now that we have our tables created, we need to finish them up... Using the JustLee diagram that we have been using in class, create all constraints for the tables (we will add the data NEXT week)... Do not forget the dependencies that exist between tables and keys...you need to make sure you create constraints in the proper order!!!...for example, in JustLee, you cannot create the foreign key 'Customer#' in the ORDERS table until you create the primary key 'Customer#' in the CUSTOMERS table... Also…as with last week’s homework, my expectation is that you define the fields based on the data they contain (i.e., do NOT make every character field 100 characters) and you must use the naming standards we discussed (i.e., XXX_XXX_XXX)... ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region BOOKAUTHOR AUTHOR ISBN AuthorID Lname Fname BOOKS ISBN Title Pubdate PubID Cost Retail Discount Category ORDERITEMS Order# Item# ISBN Quantity Paideach PUBLISHER PubID Name PROMOTION Contact Phone Gift Minretail Maxretail

Play audio

Feedback

Question

Please give Ace some feedback