Question

Consider the schema R = (A,B,C,D,E,F) on which the following functional dependencies hold: • A ? B • BC ? D • E ? C • D ? A What are the candidate keys, primary key and Secondary keys of R? Also mention 10 super keys.

          Consider the schema R = (A,B,C,D,E,F) on which the following functional dependencies hold:
• A ? B
• BC ? D
• E ? C
• D ? A
What are the candidate keys, primary key and Secondary keys of R? Also mention 10 super keys.

Added by Megan L.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Akash M

12/11/2023

Step 1

Step 1: To find the candidate keys, we need to find the minimal sets of attributes that can determine all other attributes in the relation. Show more…

Show all steps

Thanks for your feedback!

Consider the schema R = (A,B,C,D,E,F) on which the following functional dependencies hold: • A→B • BC → D • E-C • D-A What are the candidate keys, primary key and Secondary keys of R? Also mention 10 super keys.