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
1Running head: DATABASE MANAGEMENT SYSTEMSDATA BASE MANAGEMENT SYSTEMS
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
|6
|324
|168

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

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

Database Relation Normalization | Assignment
|7
|837
|276

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

Report On Normalization | Dependency Diagram | 3NF
|6
|173
|137