Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Normalization Given the following PVFC Customer Invoice Customer 10 2 Customer Name Value Furniture Address 15145 S W 17th S Plano TX 75022 Order ID
Normalization Given the following PVFC Customer Invoice Customer 10 2 Customer Name Value Furniture Address 15145 S W 17th S Plano TX 75022 Order ID Order Date 1006 10/24/2010 Product ID 7 Product Description Finish Quantity Unit Price Dining Table Natural Ash $800.00 Cherry 2 $325.00 ertainment Center Natural Male 0.00 Extended Price $1,000.00 50.00 Total $9.000.00 Please follow the following steps in converting this to a 3NF database 1. Create a single entity fromthe invoice that is in 1NF. Do not introduce any additional attributes. Only the attributes that exist in the invoice may be used in your iteration (5 pts) Identify the insertion, deletion and update anomalies that exist(5 pts) Express the functional dependencies in the entity (5 pts) 2. Your entity should not be in 2NF at this point, Explain why (5 pts) 3. Proceed to put your entity in 2NF by removing partial dependencies (10 pts) 4. Do your entities have any transitive dependencies? If yes identify them (5 pts) 5. Put your entities in 3NF if it has any transitive dependencies (5 pts) What to turn in. For each step please express your entities in the form one-dimensional tables and express the attribute dependencies with arrows or some equivalent means. All other answers/explanations take the form of simple text descriptions. For example Functional Dependencies in Student StudentId StuName Courseld CourseName Grade Normalization Given the following PVFC Customer Invoice Customer 10 2 Customer Name Value Furniture Address 15145 S W 17th S Plano TX 75022 Order ID Order Date 1006 10/24/2010 Product ID 7 Product Description Finish Quantity Unit Price Dining Table Natural Ash $800.00 Cherry 2 $325.00 ertainment Center Natural Male 0.00 Extended Price $1,000.00 50.00 Total $9.000.00 Please follow the following steps in converting this to a 3NF database 1. Create a single entity fromthe invoice that is in 1NF. Do not introduce any additional attributes. Only the attributes that exist in the invoice may be used in your iteration (5 pts) Identify the insertion, deletion and update anomalies that exist(5 pts) Express the functional dependencies in the entity (5 pts) 2. Your entity should not be in 2NF at this point, Explain why (5 pts) 3. Proceed to put your entity in 2NF by removing partial dependencies (10 pts) 4. Do your entities have any transitive dependencies? If yes identify them (5 pts) 5. Put your entities in 3NF if it has any transitive dependencies (5 pts) What to turn in. For each step please express your entities in the form one-dimensional tables and express the attribute dependencies with arrows or some equivalent means. All other answers/explanations take the form of simple text descriptions. For example Functional Dependencies in Student StudentId StuName Courseld CourseName Grade
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started