Question

Nicole wants to create a database to collect information about sales transactions. She would like to use the database to look up customer names and sales prices if they return a product. She would also like to retrieve their credit card number in order to reimburse them. In addition, she would like to sort the items in the database by product number. What fields should she have in her database?

A.product number, product description, and sales price
B.product description, sales price, and employee name
C. last name, first name, telephone number, and address
D. name, credit card number, product number, and sales price

Answer 1

The correct answer is: D. name, credit card number, product number, and sales price

Although the database would have all the fields that she would need, it would still be better if the NAME field would be split into 2 or 3 parts. This is a practice that is done in the industry to keep information more clear as there are a couple of cases where people change their names due to different reasons.

Answer 2

D. name, credit card number, product number, and sales price