Create a relationship between the two tablein the database using Supplier ID as thecommon field. Enforce Referential Integrity and select both Cascade options. One supplier can supply many inventory items$\mathrm{.}9$Create a relationship report. Save the report with Cap$1$ Relationships as the name. Close the Relationships window$\mathrm{.}410$Create a query in Design view, using your Cap Inventory table to answer the question What is the item name $($in alphabetical order$),$ cost$,$ and category for the sport of fitness? Add the fields in that order. Do not display the Sport field in the query results. Run the query, save it as Cap$1$ Fitness Query, then close the query. Five records match the criteria.