Register

Number of super_keys

• retagged by
305 views

1 Answer

2 votes
2 votes
since ph is multivalued attribute. it will have separate table.

in the table containing attribute salary, attributes can be eno,ename, dept,ndependent along with salary.

total number of superkeys= # superkeys when eno is key + #superkeys when ename is key

- # superkeys when both eno and ename as key

                                             = 2^3+2^3-2^2

                                            =8+8-4=12
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
ssm asked 6 days ago
65 views
Number of Super Keys
R(A1, A2,A3,A4....AN). How many super keys possible in relation? If (A1 is candidate key, A2 is candidate key, A3 is candidate key)
R(A1, A2,A3,A4....AN). How many super keys possible in relation? If (A1 is candidate key, A2 is candidate key, A3 is candidate key)
User Avatar
0 votes
0 votes
0 answers
2
supratikde707 asked Jan 9
173 views
Topic name:Finding number of Cnadiadte and Super Keys
r=(a1,a2,a3,...a8) assumne that a1a2a3 is a canidate key and other cks we dont know.Then find the number of possible candidate keys and number of superkeys?
r=(a1,a2,a3,...a8) assumne that a1a2a3 is a canidate key and other cks we dont know.Then find the number of possible candidate keys and number of superkeys?
User Avatar
0 votes
0 votes
1 answer
3
Harsh Saini_1 asked Dec 27, 2023
398 views
Number of Conflict Serializable Schedules
How many total $Conflict$ $Serializable$ $Schedules$ are possible that can be formed by $T1$ and $T2?$ $T1:$ $r_1(A)$ $r_1(B)$ $w_1(B)$ $T2:$ $r_2(B)$ $r_2(A)$ $w_2(B)$
How many total $Conflict$ $Serializable$ $Schedules$ are possible that can be formed by $T1$ and $T2?$$T1:$ $r_1(A)$ $r_1(B)$ $w_1(B)$$T2:$ $r_2(B)$ $r_2(A)$ $w_2(B)$
User Avatar
Link Copied!