Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q1: Consider the sample data below. What are the functional dependencies you can identify? Exclude any dependencies you think are unlikely to hold given
Q1: Consider the sample data below. What are the functional dependencies you can identify? Exclude any dependencies you think are unlikely to hold given a large sample. Order Date (A) (B) Customer (c) Item Product (D) (E) Category (F) Quantity (G) Price (H) 37 2/17/2019 PG&E Corp. 1 Corsair Dominator Storage 150 1314.99 Platinum 37 2/17/2019 PG&E Corp. 2 Kingston HyperX Beast Storage 129 863.05 37 2/17/2019 PG&E Corp. 3 EVGA Classified Mother Board 100 283.98 98 3/17/2018 Southern 1 Gigabyte X299 AORUS Gaming 7 Mother Board 104 399.99 98 3/17/2018 Southern 2 AMD FirePro S7000 Video Card 44 1218.5 Q2: What dependencies do you think will be unlikely to hold given more data? Q4: What is the fully functional schema for the relation for the schema in Q1?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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