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

a. Create a new table for Suppliers.

b. Change the structure of the original baseball inventory table

c. Specify referential integrity relationship between the two tables

d. Create a query to display the all information (including supplier information) from two tables.

e. Create a query to display the item id, description, cost, and units on hand of all items supplied by Beverage Holders

f. Try to change Supplier Code in both tables, and report what happened

g. Specify cascade update relationship between the two tables

h. Try to change Supplier Code in both tables, and report what happened

i. Specify cascade delete relationship between the two tables

j. Try to delete a record in both tables, and report what happened

Please submit the Access file, and the report in a Word/pdf file to Canvas

2. Use the baseball database you created (now you have two tables) for this assignment. Write SQL queries (You need to write by yourself by using the format of the book, and you can still test them in Access from SQL View):

(a). Display the item id, description, and on-hand value (unitsOnhand*cost), supplier name of all items.

(b) Display the average selling price of supplier Logo Goods (we only know this supplier name) items. Use Join

(c) Display the average selling price of supplier Logo Goods (we only know this supplier name) items. Use Subquery

Heres the database files link https://ufile.io/ysfmn

Thanks