Trusted by 2+ million users, 1000+ happy students everyday
Showing pages 1 to 2 of 5 pages
1Running head: DATABASE MANAGEMENT SYSTEMSDATA BASE MANAGEMENT SYSTEMS
2DATABASE MANAGEMENT SYSTEMSAssessment 2NormalizationThe given table is already in First Normal Form since it does not contain any repeating groups[ CITATION Cze17 \l 1033 ]. We therefore create the dependency diagram showing the functional dependencies in the presented relation.Prod_codeProd_NameQuantity_soldPurchase_dateProd_priceInv_NoInv_DateVendor_IDVendor_NamePartial dependencyPartial dependencyTransitive dependencyPKDecomposing it into a set of 3NF relations, we first move to 2NF from the given 1NF by having INVOICE, in its optimal form[ CITATION Wil82 \l 1033 ].Prod_codeInv_NoInv_DateWe are going to be left with PRODUCTS as shown below:
Found this document preview useful?
You are reading a preview Upload your documents to download or Become a Desklib member to get accesss