retagged by
494 views

2 Answers

Best answer
1 votes
1 votes

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)

selected by
1 votes
1 votes

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)

edited by

Related questions

0 votes
0 votes
0 answers
1
Harsh Kumar asked Dec 11, 2018
492 views
Can primary keys be updated using sql update query?Is such a query accepted/rejected?
1 votes
1 votes
2 answers
2
ajaysoni1924 asked May 22, 2018
707 views
What should be correct option for 1. and why...?