Can I read Understanding Transitive Dependencies in Databases on EtoBox?
Understanding Transitive Dependencies in Databases by lanyliel Estano is a document available to read on EtoBox.
What is Understanding Transitive Dependencies in Databases about?
The document describes normalizing a table called PART SUPPLIER into third normal form (3NF). It lists the functional dependencies and identifies candidate keys for the original table. Anomalies like insert, delete, and modify are identified. Finally, three new tables - Part, Vendor, and PartVendor - are created to normalize the data into 3NF and remove the anomalies.
- Author
- lanyliel Estano
- Language
- EN