Number of super_keys

Question

Comments

I think Answer is 64 super keys

---

24

Answer 1

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

Comments

I think it shud be 2⁴​ + 2⁴​ - 2³  = 24 ..

---

I think 24