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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!