Question#1 For the database below we have one table representing a company's data on their products and customers. Analyse the database performance and provide the best normalized form of the given table. Table abbreviations are: OID = Order ID, Q Date= Order Date, CID = Customer ID, C Name = Customer Name, C State Customer's State, PID = project id, P Desc-Project Name, P Price = Product Price, Qty = Quantity Purchased. Functional Dependencies are: OID -> Q Date CID -> C Name PID -> P Desc PID -> P Price OID -> CID CID -> C State PID and OID -> Qty OID 1006 1007 Date CID 10/24/09 2 10/25/09 6 C Name C State PID Apex Acme NC GA 7, 5, 4 11,4 P Desc P Price Qty Table, Desk, Chair Dresser, Chair 800, 1, 1,5 325, 200 500, 200 4,6
Question#1 For the database below we have one table representing a company's data on their products and customers. Analyse the database performance and provide the best normalized form of the given table. Table abbreviations are: OID = Order ID, Q Date= Order Date, CID = Customer ID, C Name = Customer Name, C State Customer's State, PID = project id, P Desc-Project Name, P Price = Product Price, Qty = Quantity Purchased. Functional Dependencies are: OID -> Q Date CID -> C Name PID -> P Desc PID -> P Price OID -> CID CID -> C State PID and OID -> Qty OID 1006 1007 Date CID 10/24/09 2 10/25/09 6 C Name C State PID Apex Acme NC GA 7, 5, 4 11,4 P Desc P Price Qty Table, Desk, Chair Dresser, Chair 800, 1, 1,5 325, 200 500, 200 4,6
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 11RQ
Related questions
Question
Transcribed Image Text:Question#1
For the database below we have one table representing a company's data on their products and
customers. Analyse the database performance and provide the best normalized form of the given
table.
Table abbreviations are:
OID = Order ID, Q Date= Order Date, CID = Customer ID, C Name = Customer Name, C State =
Customer's State, PID=project id, P Desc-Project Name, P_Price = Product Price,
Qty = Quantity Purchased.
Functional Dependencies are:
OIDO Date
CID -> C Name
PID -> P Desc
PID -> P Price
OID -> CID
CID -> C State
PID and OID -> Qty
OID
1006
1007
O Date CID
10/24/09 2
10/25/09 6
C Name
Apex
Acme
C State PID
NC
GA
7, 5, 4
11,4
P Desc
Table,
Desk,
Chair
Dresser,
Chair
P Price Qty
800,
325,
200
500,
200
1, 1,5
4, 6
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
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
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
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
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage