Question: 1. View the following poorly design database design. 2. Identify as many errors as you can find. Focus particularly on the following: Table formatting Data

1. View the following poorly design database design.
2. Identify as many errors as you can find. Focus particularly on the following:
Table formatting
Data types
Field length
Relationships
Primary Keys
Foreign Keys
3. Summarize 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.
**I NEED HELP WITH THE SECOND TABLE**
Order Table (Forma Customer Table (Format Name of Text 5 AddressTex City Products Table (Forma Item ID Number Quantity inLong Integer Text 5 Customer Full Name Text 50 Text 50 Stock Date Text 50 Quantity OrderedLong Text 50 Integer Long Integer Text 50 Price Long Integer Total Price State Date Social Long Integer Number Zi Long Inte Long Integer Customer Order Item ID Number Customer Last Name Name of 1 Customer Address City in Stock 1 Date Ordered Total Price Date Price State Social Number Zip
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
