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

Plagiarism-free and delivered on time!

We are passionate about delivering quality essays.

Our writers know how to write on any topic and subject area while meeting all of your specific requirements.

Unlike most other services, we will do a free revision if you need us to make corrections even after delivery.