Natalie 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 like to sort the items in the database by product number. what fields should she have in her database?

Customer Table

Product Table

Transactions Table

Explanation:

Natalie wants to fetch following information from database

To lookup customer name and sale price perform a join on Transactions table and Customer table.Assuming database is build in mysql the query to fetch required results would be

select transction.productId,transaction.customerid,customer.customername from transactions join customer ON

customer.customerid=transcation.customerid

where productid="user provided product id of returned product"

For sorting products by number set produc number in product table a auto increment primary key