Second Semester 2020 2021 (BUSA 238) - (Management Information Systems) Microsoft Access Assignment By using Microsoft Access create database called DB_MIS and then create two tables Supplier and Product As the following requirements: ZIP Suate City Street Address Company Name Supplier Code Number 57106 SD Sioux 1459 Washington Bicyclist's Choice Falls Avenue 92110 CA San 2000 Oceanside Lane Bike-One 2 Diego 17121 NJ Long 1155 Fifth Avenue Run-Up Bikes 3 Branch 94114 OK Tulsa 107 Piedmont Simpson's Bike Supply $1937 NY Fast 1999 Stephen Hands The Bike Path 5 Hampton Path 1 4 Count In stock Supplier Selling Purchase Product Name Product Product Ordering Quantity Number Price Cost Category Number 8 7 15290.49 $217.49 Classic 109 Road 1 7 2 5 2 5 2 3 4 3 15394.13 $281.52 Elegant 210 Road 3 $350.99 $250.95 Runroad 1000 Road 2 SS61.54 401.11 Eagle 2 Mtn. 2557401 $410,01 Eagle 1 Mt. 45609.00 $429.02 Tea for Two Hybrid $ $495.00 $375.00 Bluff Breaker Mtn. 4 $133.66 595.47 Green Rider Children 5 3 6 3 3 7 5 4 8 1. Make the field Supplier Number primary key in the Supplier table 2. Make the field Product Number primary key in the Product table 3. Make the field Company Name required field (Hint: see the properties of the field) Catequery of the following fields Product number, Product Category Product Name, Selling Price Supplier Name, City, State where count ordering greater than 4 The Wood Furniture company produces a specialty wood furniture product, and has the following information available concerning its inventory items: relevant ordering costs per purchase order $120. Relevant carrying costs per unit $4. Annual demand is 15,000 packages per year. What is the economic order quantity Select one: a. 949 units Ob 15,000 units O c. 1,000 units O d. 1225 units