Answer to Question #191230 in Databases | SQL | Oracle | MS Access for Nana kofi

Question

The following table shows the essential data required for this application. Hillar Furniture Company Purchasing Data is shown below: Attribute Name Material_ID Material_ Name Unit_of_Measure Standard_Cost Vendor_ID Vendor_name Unit_price Terms_Code Terms Sample Value 3792 Hinges 3” locking Each GHC 5.00 V300 Apex Hardware GHC 4.75 1 COD a) Using the dependency diagram, identify the functional dependencies for this data. You may assume the following: i. Each material has one or more suppliers. Each supplier may have supply one or more items or may not supply many items. ii. The unit price for a material may vary from one vendor to another iii. The terms of a code for a supplier uniquely identifies the terms of a sale (e.g. code 2 means 10% net 30 days, etc.). The terms for a supplier are the same for all material items ordered from that supplier. [E][9] b) Convert your data into a set of 3NF relations, identifying all the primary and foreign keys

Answer 1

Dear Nana kofi, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order