Question: 2. Give a necessary and sufficient condition for a decomposition of R into R1 and R2 to be lossless join. Very briefly explain why the

2. Give a necessary and sufficient condition for a decomposition of R into R1 and R2 to be lossless join. Very briefly explain why the condition is necessary and sufficient. a. [10 points] b. Given F IA- B, A-C, CG->H, CG>I, B-H), set of functional dependencies on R(A, [10 points] c. Identify possible functional dependencies from the following schema of car-sell relation B, C, G, H, I), check if A is a candidate key of R. used by a Toyota dealer, Car-sell (transactionID customerlD, CustomerName, customerAddress, carModel, 15 points] [10 points] MakeYear, carPrice, NoOfSeats) d. Check if the schema car-sell of (c) is in BCNF form. Explain your
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
