database assignment (You may complete your assignment using Word or Excel, but you will have better results using diagramming software such as Visio or Draw.io.).
I need support with this Accounting question so I can learn better.
Ashton wants to store the following data about S&S’s purchases of inventory:
date of purchase
purchase order number
quantity on hand
total amount of purchase
a. Design a set of relational tables to store this data. Name each table and field in accordance with good database design.
b. Do all the data items need to be stored in a table? If not, which ones do not need to be stored, and why do they not need to be stored?
c. Identify the primary key for each table.
d. Identify the foreign keys needed in the tables to implement referential integrity.
e. Create an entity relationship diagram (ERD) of your database design. Use crow’s feet notation.