logo

Database Relation Normalization | Assignment

7 Pages837 Words276 Views
   

Added on  2020-02-24

Database Relation Normalization | Assignment

   Added on 2020-02-24

ShareRelated Documents
Running Head: DATABASE RELATION NORMALIZATION 1Database Solutions 3NF Normalization [Student Names][Institution Name]
Database Relation Normalization | Assignment_1
DATABASE RELATION NORMALIZATION 1 2Dependency diagram showing the functional dependencies in therelation.Prod_code Prod_NamePurchase_dateQty_soldProd_priceInv_NoInv_DateVendor_IDVendor_Name
Database Relation Normalization | Assignment_2
DATABASE RELATION NORMALIZATION 1 3Decomposed 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_code Prod_NamePurchase_dateThe above PRODUCTS relations from the above dependency diagram is in 3NF due to following :i.There is no repeating attribute in the relations.ii.The other attributes in the relations depends on the primary key Prod_code.iii.The only dependencies are functional and transitive and therefore this relation in 3NF.SALESInv_NoQty_sold Prod_priceInv_DateProd_codeThe above SALES relations from the above dependency diagram is in 3NF due to following :i.There is no repeating attribute in the relations.ii.The other attributes in the relations depends on the primary key Inv_No and a foreign key prod_code that references PRODUCTS table.iii.The only dependencies are functional and transitive and therefore this relation in 3NF.VENDORSVendor_IDVendor_NameProd_code
Database Relation Normalization | Assignment_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
A Study on Functional Dependency and Relational Schema
|7
|557
|237

Database Schema Design Using Entity-Relationship Approach
|7
|567
|303

Entity Relationship Diagram and Schema | Assignment
|5
|141
|54

Database Management Systems - Assignment
|6
|324
|168

Assessment on Database Management System
|5
|388
|262

Home Inventory Database | Assignment
|9
|1147
|411