Design Theory for Relational Database

Computer Science
Tutor: None Selected Time limit: 1 Day

1.         Suppose R is a relation with attributes A1, A2,..., An. As a function of n, tell how many superkeys R has, if

1.1  The only key is A1.

1.2  The only key is A1 and A2.

1.3  The only key is {A1 A2} and {A3 , A4}.

1.4  The only key is {A1 A2} and {A1 , A3}.
Jun 10th, 2015

Thank you for the opportunity to help you with your question!

if the only key is A1  R will have one superkeys

1.2 only key is A1 and A2 will have four superkeys

1.3 16 superkeys

1.4 100 superkeys


Please let me know if you need any clarification. I'm always happy to answer your questions.
Jun 10th, 2015

Oh .. Thank you so much .. May I request for details to clarify the above above answers in 1.1 to 1.4 please.

Jun 10th, 2015

Thank you for your timely response and assistance. May I request for the details to clarify how the answers are arrived at please.

Jun 10th, 2015

Did you know? You can earn $20 for every friend you invite to Studypool!
Click here to
Refer a Friend
...
Jun 10th, 2015
...
Jun 10th, 2015
Dec 3rd, 2016
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer