Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercise 7: Given: Sale(customer, store, product, price) and the constraints: A customer buys from only one store. There is a unique price for each product
Exercise 7: Given: Sale(customer, store, product, price) and the constraints: A customer buys from only one store. There is a unique price for each product in a store, but the same product can have a different price in different stores. a) What are the FDs implied by the above description? b) What are the candidate keys? c) Explain why Sale is not in 3NF. d) Decompose Sale into 3NF. e) Is the decomposition dependency preserving? Why
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