(Answered): Required: Use the ER-diagram to create a data dictionary. Use the following template: Raw_Materials ...

Required: Use the ER-diagram to create a data dictionary. Use the following template: Raw_Materials Raw Materials Code Raw_Materials_Description Raw Materials_Price Purchase_Orders 8 Purchase Order_ID Purchase_Order_Date Purchase_Employee_ID Supplier_ID Raw_Materials Code Quantity_Purchased Raw_Material Purchase Price Suppliers Supplier_ID Supplier_Company_name Supplier_Address Supplier_City Supplier_St Supplier_Zip Supplier_Phone Notes (Choose "N/A" whenever "Primary key" or "Foreign Key" is not applicable.) Table Primary or Foreign Key? Required? Description Data Type Y numeric Default Value Next sequential number n/a Raw_Materials short text n/a currency numeric Y Y Y Y Y Y date Next sequential number current date n/a n/a Purchase_Orders numeric numeric numeric numeric Y Attribute Name Raw_Materials_Code Raw_Materials_Description Raw Materials Price Purchase_Order_ID Purchase_Order_Date Purchase_Employee_ID Supplier_ID Raw_Materials_Code Quantity_Purchased Supplier_ID Supplier_Company_Name Supplier_Address Supplier_City Supplier_St Supplier_Zip Supplier_Phone Notes n/a Y Y numeric n/a Next sequential number n/a Y short text Y short text n/a Suppliers Y Y Y short text short text numeric n/a n/a n/a n/a Y short text short text N n/a