[solved]-1 Use Baseball Database Save Baseballlec3 Created Previous Assignment Access Create New T Q39067788

1. Use the Baseball database (save as BaseballLec3) you createdin previous for this assignment. By Access:(a). Create a new tablefor Suppliers.(b). Change the structure of the original baseballinventory table(c). Specify referential integrity relationshipbetween the two tables(d). Create a query to display the allinformation (including supplier information) from two tables. Don’tduplicate the values of field(s). (e). Create a query to displaythe item id, description, cost, and units on hand of all itemssupplied by Beverage Holders (f) Find the lowest and highestselling price(g) Display the average selling price of supplier BH’sitems(h) Find a count of different types of items grouped bysupplier names

Expert Answer

---

Answer to 1. Use the Baseball database (save as BaseballLec3) you created in previous for this assignment. By Access:(a). Create a… . . .