Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Consider the following relation:   Invoice(Order_ID, Order_Date, Customer_ID, Customer_Name,Customer_Address,Product_ID, Product_Desc, Price, Order_Quantity)   FD1 - Order_ID -> Order_Date, Customer_ID, Customer_Name, Customer_Address   FD2 - Customer_ID -> Customer_Name, Customer_Address   FD3 - Product_ID -> Product_Description, Price   FD4 - Order_ID, Product_ID -> Order_Quantity   What are the candidate keys of this relation? Give reasons to explain if this is in 1NF or not. If not, decompose it to 1NF. Give reasons to explain if this is in 2NF or not. If not, decompose it to 2NF. Give reasons to explain if this is in 3NF or not. If not, decompose it to 3NF.

Consider the following relation:   Invoice(Order_ID, Order_Date, Customer_ID, Customer_Name,Customer_Address,Product_ID, Product_Desc, Price, Order_Quantity)   FD1 - Order_ID -> Order_Date, Customer_ID, Customer_Name, Customer_Address   FD2 - Customer_ID -> Customer_Name, Customer_Address   FD3 - Product_ID -> Product_Description, Price   FD4 - Order_ID, Product_ID -> Order_Quantity   What are the candidate keys of this relation? Give reasons to explain if this is in 1NF or not. If not, decompose it to 1NF. Give reasons to explain if this is in 2NF or not. If not, decompose it to 2NF. Give reasons to explain if this is in 3NF or not. If not, decompose it to 3NF.

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter11: Database Performance Tuning And Query Optimization
Section: Chapter Questions
Problem 21P: Problems 1721 are based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM...
See similar textbooks
icon
Related questions
Question
100%

Question 6.

 

Consider the following relation:

 

Invoice(Order_ID, Order_Date, Customer_ID, Customer_Name,Customer_Address,Product_ID, Product_Desc, Price, Order_Quantity)

 

FD1 - Order_ID -> Order_Date, Customer_ID, Customer_Name, Customer_Address

 

FD2 - Customer_ID -> Customer_Name, Customer_Address

 

FD3 - Product_ID -> Product_Description, Price

 

FD4 - Order_ID, Product_ID -> Order_Quantity

 

What are the candidate keys of this relation?

Give reasons to explain if this is in 1NF or not. If not, decompose it to 1NF.

Give reasons to explain if this is in 2NF or not. If not, decompose it to 2NF.

Give reasons to explain if this is in 3NF or not. If not, decompose it to 3NF.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 9 steps with 9 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Normalization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS