Assignment Tables Identify as many errors as you can find. Focus particularly on

Question

Assignment

Tables

Identify as many errors as you can find. Focus particularly on the following:

Table formatting

Data types

Field length

Relationships

Primary Keys

Foreign Keys

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.

Assignment

Tables

Customer Table (Format) Product Table (Format) Order Table(Format) Name of Customer Text 5 Item ID Number Text 50 Customer Full Name Text 50 Address Text 50 Quantity in Stock Long Integer Product Text 50 City Text 50 Date Text 50 Quantity Ordered Long Integer State Text 50 Price Long Integer Total Price Long Integer Social Security Number Long Integer Date Zip Long Integer Phone Long Integer Relationships Customer Order Product Name of Customer Customer Full Name Address Product Item ID Number City Quantity Ordered Quantity in Stock State Total Price Price Social Security Number Date Date Zip Phone

Explanation / Answer

Please find below our detailed findings:

1. Customer Table

2. Product Table

3. Order Table

Relationships

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.