1. Use the Baseball database (save as YourLastNameLec3) you created in the first week for this assignment. By Access: (1a). Create a new table for Suppliers (Note: the data is from the week 1 assignment) (1b). Change the structure of the original baseball inventory table by removing suppliers' information (Note: keep the SupplierCode) (1c). Specify referential integrity relationship between the two tables Then create Access GUI queries (please save each query) (1d). Display the all information (including supplier information) from two tables. Dont duplicate the values of field(s). (1e). Display the item id, description, cost, and units on hand of all items supplied by Beverage Holders (1f) Find the lowest and highest selling price (1g) Display the average selling price of supplier BHs items (1h) Find a count of different types of items grouped by supplier names.