1. Find all candidate keys for relation R(ABCDE). Following functional depen- dencies exist in relation R:...

Transcribed Image Text:

1. Find all candidate keys for relation R(ABCDE). Following functional depen- dencies exist in relation R: AB, BC ⇒ E, ED → A 2. Given relation R(ABCDEF) and following functional dependencies: F = {A → BC, E → ABC, F→ CD, CD → BEF} Determine all candidate keys! 3. Given two sets of functional dependencies: AB, AC, CD → E, B → D ABC, AD →E, DB→B, A D 1. Find all candidate keys for relation R(ABCDE). Following functional depen- dencies exist in relation R: AB, BC ⇒ E, ED → A 2. Given relation R(ABCDEF) and following functional dependencies: F = {A → BC, E → ABC, F→ CD, CD → BEF} Determine all candidate keys! 3. Given two sets of functional dependencies: AB, AC, CD → E, B → D ABC, AD →E, DB→B, A D

Answer rating: 100% (QA)

Here are the solutions for each part 1 Finding candidate keys for relation RABCDE Functional dependencies A B BC E ED A Candidate keys AC and BD Expla... View the full answer