The following data is to be used in developing a new database system for a fictitious company:

Customer name
Customer address
Date of purchase
Amount of purchase
Item purchased
Quantity purchased
Salesperson
Invoice number
Item number

Design a set of relational tables to store this data. Do all of the data items need to be stored in a table? If not, which ones do not need to be stored, and why not?
Identify what data should be included in each table.