Use the ER-diagram to create a data dictionary. Use the following template: Raw Materials Raw Materials_Code...

Transcribed Image Text:

Use the ER-diagram to create a data dictionary. Use the following template: Raw Materials Raw Materials_Code Raw Materials Description Raw Materials Price Table Raw Materials Purchase Orders Suppliers (Choose "N/A" whenever "Primary Key" or "Foreign Key" is not applicable.) 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 00 Supplier_ID Supplier_Company Name Supplier_Address Supplier_City Supplier_St Supplier Zip Supplier_Phone Notes Purchase Orders Purchase_Order_ID Purchase Order_Date Purchase Employee_ID Supplier_ID Raw Materials Code Quantity_Purchased Raw Material Purchase Price Primary or Foreign Key? Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y |N Required? Suppliers Supplier_ID Supplier Company_name Supplier_Address Supplier_City Supplier_St Supplier Zip Supplier Phone Notes Description Data Type numeric short text currency numeric date numeric numeric numeric numeric numeric short text short text short text short text numeric short text short text Default Value Next sequential number n/a n/a Next sequential number current date n/a n/a n/a n/a Next sequential number n/a n/a n/a n/a n/a n/a n/a Use the ER-diagram to create a data dictionary. Use the following template: Raw Materials Raw Materials_Code Raw Materials Description Raw Materials Price Table Raw Materials Purchase Orders Suppliers (Choose "N/A" whenever "Primary Key" or "Foreign Key" is not applicable.) 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 00 Supplier_ID Supplier_Company Name Supplier_Address Supplier_City Supplier_St Supplier Zip Supplier_Phone Notes Purchase Orders Purchase_Order_ID Purchase Order_Date Purchase Employee_ID Supplier_ID Raw Materials Code Quantity_Purchased Raw Material Purchase Price Primary or Foreign Key? Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y |N Required? Suppliers Supplier_ID Supplier Company_name Supplier_Address Supplier_City Supplier_St Supplier Zip Supplier Phone Notes Description Data Type numeric short text currency numeric date numeric numeric numeric numeric numeric short text short text short text short text numeric short text short text Default Value Next sequential number n/a n/a Next sequential number current date n/a n/a n/a n/a Next sequential number n/a n/a n/a n/a n/a n/a n/a