Normalization of Database Tables to Third Normal Form (3NF)

Preview (2 of 4 Pages)

100%

Normalization of Database Tables to Third Normal Form (3NF) - Page 1 preview image

Loading page ...

Normalization of Database Tables to Third Normal Form (3NF)Order IDOrderDateCustomerIDCustomer NameProductIDProduct Desc.ProductPriceQuantityOrdered100610/24/102Value Furniture754Dining TableWriters DeskEntertain Center800.00325.00650.00221100710/25/106Furniture Gallery1144 Drawer DresserEntertain Center500.00650.00431.Describe the steps you would take to bring the table(s) into third normal form compliance. Display the resulting thirdnormal formcompliant table or tables, identifying primary and foreign keys.Answer:R is in 3NF if and only if, for every FD X→A in R, at least one of the following is true:1. X contains A (so the FD is trivial).2. X is a superkey.3. A is contained in a candidate key of R.Step 1:Breaktheproduct table and create a price table to map the price of each product accurately.Step 2:Create a product table and other Product Price table.Product table:Product ID: Primary keyProductPriceID:Foreign keyProductIDProduct Desc.7Dining Table5Writers Desk

Normalization of Database Tables to Third Normal Form (3NF) - Page 2 preview image

Loading page ...

Preview Mode

This document has 4 pages. Sign in to access the full document!

Report

Study Now!

Document Details

Related Documents

DevOps and Its Importance Study Notes

Veeam Certified Engineer VMCE-V12

Modules 1 - 3 Basic Network Connectivity and Commu

Notes CCNA

CCNA 200-301 Portable Command Guide 5th Edition 20

CCNA 200-301 Portable Command Guide 5th Edition 22

CCNA 200-301 Portable Command Guide 5th Edition 36

Foundations of Novell Networking Section 26

Modulo 7 DHCPv4

Build and troubleshooting Integration Challenge

Company

Explore

Study Tools