Assessment on Database Management System

Added on -2020-02-23

| 5 pages| 388 words| 262 views

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

Premium

$45

Q&A Library Access

Chat support

12

Document Unlocks

4

Answer Unlocks

Students who viewed this