Can I read Normalization of Invoices and Vendors on EtoBox?

Normalization of Invoices and Vendors by n02021908g is a document available to read on EtoBox.

What is Normalization of Invoices and Vendors about?

The document describes normalizing tables to eliminate partial and transitive dependencies. It identifies the partial dependencies in an original table as InvoiceNo → SaleDate, VendorCode, VendorName and ProductNo → ProductDescription, ProductPrice. It then describes transforming the table into 2NF by creating two new tables - one for invoices with the invoice details, and one for products with product details. It further identifies a transitive dependency of VendorCode → VendorName and transforms the table

Author

n02021908g

Language

EN