Question: Consider a relation R with attributes ABCDEFGH and functional dependencies S: S = { A CD , ACF G , AD BEF , BCG D

Consider a relation R with attributes ABCDEFGH and functional dependencies S: S ={ACD, ACFG, ADBEF, BCGD, CFAH, CHG, DB, HDEG}1. Compute all keys for R.2. Compute a minimal basis for S. In your final answer, put the FDs into alphabetical order. 3. Using the minimal basis from the previous step, employ the 3NF synthesis algorithm to obtain a lossless and dependencypreserving decomposition of relation R into a collection of relations that are in 3NF.4. Does your schema allow redundancy? Explain all your answers and show your rough work.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!