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 Table Raw
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
Step by Step Solution
3.37 Rating (153 Votes )
There are 3 Steps involved in it
To complete the data dictionary we need to determine the primary key PK and foreign key FK attributes from the ER diagram specify if they are required ... View full answer
Get step-by-step solutions from verified subject matter experts
