Poorly design database design

by | Sep 10, 2021 | Homework Help

View the following poorly design database design.Identify as many errors as you can find. Focus particularly on the following:Table formattingData typesField lengthRelationshipsPrimary KeysForeign KeysSummarize your findings into a bulleted list in a Word document. This list should include details and each item in the list should be unique. Points will be deducted if this is not done. Make sure that each item in the list is detailed and unique. Don’t forget to properly use references where appropriate.TablesCustomer Table (Format)Products Table (Format)Order Table (Format)Name ofText 5Item ID Number Text 50Customer Full Name Text 5CustomerAddressct 50Quantity inLong IntegerProductText 50StockCityText 50DateText 50Quantity OrderedLongIntegerStateText 50PriceLong IntegerTotal PriceLongIntegerSocialLong IntegerDateSecurityNumberZipLong IntegerPhoneLong IntegerRelationshipsCustomerOrderProductName ofY Customer LastItem ID NumberCustomerNameAddressProductQuantity in StockCityQuantity1 DateOrderedStateTotal PricePriceSocialDateSecurityNumberZipPhone

We help you get better grades, improve your productivity and get more fun out of college!!

Get Homework Answer for this question

Free title page

Free reference page

Free formatting

Unlimited revisions

Get answer to your homework