Question: 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

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 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 Raw Materials Purchase Orders 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 Primary or Foreign Key? Required? Description Data Type numeric Default Value Next sequential number short text n/a currency n/a Foreign Key numeric Next sequential number date current date N/A numeric n/a Primary Key numeric n/a Y numeric n'a Y numeric n'a Y numeric Next sequential number Y short text n'a Y short text n/a Supplier_City Y short text n/a Suppliers Supplier_St Supplier_Zip Supplier_Phone Notes Y short text n/a Y numeric n/a Y short text n'a N short text n/a Description Data Type Default Value numeric Next sequential number hort text n/a Amount of materials being purchased (per Raw Materials_Code) urrency n/a umeric Next sequential number City in which the supplier is located ate current date Employee ID of Employee who created the Purchase Order umeric n/a Free text space for notes about supplier umeric n/a Friendly name of each raw material umeric n/a numeric n/a numeric Next sequential number short text n/a short text n/a short text n/a short text n/a numeric n/a short text n/a short text n/a Price of each raw material Raw Materials_Code of the Materials being purchased State in which the supplier is located Street address for each supplier Street address for each supplier Supplier_ID of Supplier who is involved in the Purchase Supplier's phone number The date the transaction was initiated Unique identifier for each raw material Unique identifier for each supplier The date the transaction was initiated Unique identifier for each raw material Unique identifier for each supplier Unique identifier for each transaction Zip code for supplier

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!