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:
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Management Systems - Assignmentlg...
|6
|324
|168
Database Schema Design Using Entity-Relationship Approachlg...
|7
|567
|303
A Study on Functional Dependency and Relational Schemalg...
|7
|557
|237
Database Relation Normalization | Assignmentlg...
|7
|837
|276
Entity Relationship Diagram and Schema | Assignmentlg...
|5
|141
|54
Report On Normalization | Dependency Diagram | 3NFlg...