Database Relation Normalization | Assignment

Added on - 23 Feb 2020

  • 7

    Pages

  • 837

    Words

  • 148

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 7 pages
Running Head: DATABASE RELATION NORMALIZATION 1Database Solutions 3NFNormalization[Student Names][Institution Name]
DATABASE RELATION NORMALIZATION 12Dependency diagram showing the functional dependencies in therelation.Prod_codeProd_NamePurchase_dateQty_soldProd_priceInv_NoInv_DateVendor_IDVendor_Name
DATABASE RELATION NORMALIZATION 13Decomposed relation into a set of 3NF relations.The above dependency diagram can be split into three relations in 3NF which includesPRODUCTS,SALES and VENDORS relations as below:PRODUCTSProd_codeProd_NamePurchase_dateThe above PRODUCTS relations from the above dependency diagram is in 3NF due tofollowing :i.There is no repeating attribute in the relations.ii.The other attributes in the relations depends on the primary keyProd_code.iii.The only dependencies are functional and transitive and therefore this relation in 3NF.SALESInv_NoQty_soldProd_priceInv_DateProd_codeThe above SALES relations from the above dependency diagram is in 3NF due tofollowing :i.There is no repeating attribute in the relations.ii.The other attributes in the relations depends on the primary keyInv_No and a foreignkeyprod_codethat references PRODUCTS table.iii.The only dependencies are functional and transitive and therefore this relation in 3NF.VENDORSVendor_IDVendor_NameProd_code
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document