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 be able retrieve their credit-card numbers 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?

Question

Responses

product description, sales price, and employee name
product description, sales price, and employee name

product number, product description, and sales price
product number, product description, and sales price

last name, first name, telephone number, and address
last name, first name, telephone number, and address

name, credit-card number, product number, and sales price

Answer 1

For Nicole's database requirements, she needs to be able to look up customer names and sales prices, retrieve credit-card numbers for reimbursements, and sort items by product number.

The best response from the provided options would be:

name, credit-card number, product number, and sales price

This selection includes essential information about the customers (name and credit-card number), as well as key details relevant to the sales transactions (product number and sales price), which will allow her to sort and manage the sales effectively.