Ask a question from expert

Ask now

Assessment on Database Management System

5 Pages388 Words262 Views

Added on  2020-02-23

Assessment on Database Management System

   Added on 2020-02-23

BookmarkShareRelated Documents
Assessment on Database Management System_1
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:
Assessment on Database Management System_2

End of preview

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

Related Documents
Database Management Systems - Assignment

Database Schema Design Using Entity-Relationship Approach

A Study on Functional Dependency and Relational Schema

Database Relation Normalization | Assignment

Entity Relationship Diagram and Schema | Assignment

Report On Normalization | Dependency Diagram | 3NF