Made easy Test Series 2022

Question

I am getting ans 6 and given ans is 8

Answer 1

E1(A1, A2)

E2(A5, A11, A6, A7,A17)

E3(A3, A4)

E4(A9, A10, A1)

E5(A11, A15, A16)

E6(A14, A18, A13)

A14(AID) Multivalue attribute

R1(A1, A3, A5, A8)

Comments

Underlined are primary Keys

---

E-R representation:

---

For above case arrow shows: 1:1 relation

Answer 2

number of relations

1. for each entity 1 relation 
2. For M:N 3 relation
3. for multivalued attribute 1 relation
4. for each n-ary(>2) relationship 1 relation 

so 

​​​​​​E1(A1,A2)

E4(A1,A9,A10)

E3(A3,A4)

E2(A5,A6,A7,A17,A11)

R1(A8,A3,A5,A1)

E5(A11,A12)

E6(A13,A15)

E7(A13,A14)

Comments

Do we create a separate table for ternary relations?as R1(A8,A3,A5,A1)

---

Yeah, we do