P4.3 Ashton wants to store the following data about S&S's purchases of inventory: date of purchase vendor address purchase price employee number purchase order number quantity on hand total amount of purchase item number vendor number vendor name quantity purchased employee name description extended amount 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 do they not need to be stored? b. a. Identify the primary key for each table. Identify the foreign keys needed in the tables to implement referential integrity. C. Implement your tables using any relational database product to which you have access. Test your specification by entering sample data in each table. Create a few queries to retrieve or analyse the data you stored. d. e. f