Question: R = ( A , B , C , G , H , I ) A C C G H C G I B H

R=(A,B,C,G,H,I)
AC
CGH
CGI
BH
(AG)+
result =AG
result and AB
result =ABCGH
and CGsubeAGBC )
result =ABCGHI
and CGsubeAGBCH )
Is AG a candidate key?
Is AG a super key?
Does AGR?== Is (AG)+supeR
Is any subset of AG a superkey?
Does AR?== Is (A)+supeR
Does GR?== Is (G)+supeR
MacBook Pro
 R=(A,B,C,G,H,I) AC CGH CGI BH (AG)+ result =AG result and AB

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!