1. Mark as many errors as you can find. The Primary focus includes: Table format
ID: 3692711 • Letter: 1
Question
1. Mark as many errors as you can find.
The Primary focus includes: Table formatting, Data types, Field length, Relationships, Primary Keys, Foreign Keys
2. Summarize your findings into a bulleted list and include details as each item should be unique
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 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 ZipExplanation / Answer
Answer for Question:
Customer Table (Format):
Name of the Customer : Text Size must be greater than 5 because they have the first name and last Name
Address : Text 50 is fine
City : Text 50 is fine
State : Text 2 characters are fine (As per US States Names..)
SSN : Long Integer is fine
ZIP : ZIP Long Integer is fine
Phone : Long Integer is fine
Product Table(Format):
Item ID Number : It must be Long Integer Type not Text type
Quantity : Fine
Date : Date data type or Long Integer not Text type
Price : Fine
Remove the below three columns
Order Table (Format):
Name : Text size should be more than 5
Product : Fine
Period : Fine
Price : Fine
Date : Date data Type it is not empty
Remove the below three columns
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.