Question
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.
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started