When designing a database, which field would not belong in a table storing customer information?
A)Zip Code
B)Street Address
C)Last Name
D)Order Number

Question

Quizplus · Accepted Answer

The table storing customer information should not contain the order number field as it is a separate entity and should be stored in a table dedicated to order information. The other fields, such as zip code, street address, and last name, would all belong in a table storing customer information.

When Designing a Database, Which Field Would Not Belong in a Table