ACC 409/609 MS Access Database Activity Instructions: You are required to create a relational database for Awesome Sweets Inc. You need to create tables for resources ("On Hand Inventory and "On Demand Inventory') and agents ("Employees" and "Suppliers") involved in the "Get Materials Forecast" and "Give Inventory Obsolescence" events. 1. The On Hand Inventory table must have the following attributes: InvID (set as primary key) InvDescription InvStockType (type of inventory either Raw Material, Finished Goods, Supplies) Inv QtyOnHand (quantity on hand) InvCost InvPrice (for items for sale) EmpID (employee that orders de goods) SupplierID (who supplies the materials) You must generate the following data for the "On Hand Inventory table: Records of raw materials needed to manufacture (quantity on hand of materials (recipe) must be set to be able to manufacture): o 100 cakes (any flavor) o 100 dozen of cookies (any flavor) o 100 dozen of cupcakes (different flavor from cake) Five records of supplies (e.g., office supplies, cleaning supplies) Three records of finished goods (i.e., cakes, cookies, cupcakes) 2. The On Demand Inventory table must have the following attributes: InvID (set as primary key) Inv QtyOnDemand Data for the On Demand Inventory table must include all the records in the "On Hand Inventory table but the quantity on hand must be adjusted to the following demand: 50 cakes 0 dozen of cookies 100 dozen of cupcakes 3. You must determine relevant attributes to the "Employees" and "Suppliers" tables and the tables must have at least one record. 4. Create the following relationships: InviD from "On Hand Inventory table to InviD of On Demand Inventory table EmplD from On Hand Inventory table to EmpID from Employees table Supplier ID from On Hand Inventory table to SupplierID from Suppliers table ACC 409/609 MS Access Database Activity Instructions: You are required to create a relational database for Awesome Sweets Inc. You need to create tables for resources ("On Hand Inventory and "On Demand Inventory') and agents ("Employees" and "Suppliers") involved in the "Get Materials Forecast" and "Give Inventory Obsolescence" events. 1. The On Hand Inventory table must have the following attributes: InvID (set as primary key) InvDescription InvStockType (type of inventory either Raw Material, Finished Goods, Supplies) Inv QtyOnHand (quantity on hand) InvCost InvPrice (for items for sale) EmpID (employee that orders de goods) SupplierID (who supplies the materials) You must generate the following data for the "On Hand Inventory table: Records of raw materials needed to manufacture (quantity on hand of materials (recipe) must be set to be able to manufacture): o 100 cakes (any flavor) o 100 dozen of cookies (any flavor) o 100 dozen of cupcakes (different flavor from cake) Five records of supplies (e.g., office supplies, cleaning supplies) Three records of finished goods (i.e., cakes, cookies, cupcakes) 2. The On Demand Inventory table must have the following attributes: InvID (set as primary key) Inv QtyOnDemand Data for the On Demand Inventory table must include all the records in the "On Hand Inventory table but the quantity on hand must be adjusted to the following demand: 50 cakes 0 dozen of cookies 100 dozen of cupcakes 3. You must determine relevant attributes to the "Employees" and "Suppliers" tables and the tables must have at least one record. 4. Create the following relationships: InviD from "On Hand Inventory table to InviD of On Demand Inventory table EmplD from On Hand Inventory table to EmpID from Employees table Supplier ID from On Hand Inventory table to SupplierID from Suppliers table