logo

Report On Normalization | Dependency Diagram | 3NF

6 Pages173 Words137 Views
   

Added on  2020-02-24

Report On Normalization | Dependency Diagram | 3NF

   Added on 2020-02-24

ShareRelated Documents
NormalisationStudent ID –Student Name –Subject Code - Date -
Report On Normalization | Dependency Diagram | 3NF_1
Report Dependency DiagramProduct Name, Product Price, Vendor ID and Vendor Name depends upon the ProductCode.ProductName ProductCodeProductPrice ProductCodeVendorID ProductCodeVendorName ProductCodePurchase Date and Invoice Date depends upon the InvoiceNumber.PurchaseDate InvoiceNumberInvDate InvoiceNumber Vendor Name depends upon the Vendor ID.VendorName VendorIDSold Quantity depends upon the Pruduct Code and Invoice Number.QuantitySold ProductCodeQuantitySold InvoiceNumber(Brombarg P. n.d.)
Report On Normalization | Dependency Diagram | 3NF_2
3NF Relations1 NF2 NF
Report On Normalization | Dependency Diagram | 3NF_3

End of preview

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

Related Documents
Student ID: Student Name: Date:.
|4
|74
|66

Report | Dependency Diagram
|6
|137
|49

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

Report Dependency Diagram
|6
|149
|84

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

March 12. Database Normalization. Student ID: Student N
|4
|370
|229