retagged by
1,606 views

2 Answers

Best answer
4 votes
4 votes

5 Relations


Each for Strong Entity sets : E1 and E2, this contributes +2 (A, B, C) and (D, E, F)
One for M:N type Relationship Set : R, this contributes  +1 (A, D)
One relation for each Multi Valued Attribute which preserves Multi Valued Attribute's data : C and F, this contributes +2 (C, C') and (F, F') where C' and F' are the multiple values corresponding to each C and F respectively. 

a total of 5 Relations. Here, in all relations the determinant is a super key. So, all are in BCNF and we cannot reduce the number 5 ensuring BCNF. 

Ref: http://web.cse.ohio-state.edu/~gurari/course/cse670/cse670Ch9.xht

edited by
0 votes
0 votes
4 according to me ...2 for strong entities and 2 for multivalued attribute ...where did 5th one come in fromwhere isit given m:n is cardinality ?

Related questions

0 votes
0 votes
0 answers
1
Ashutosh_17 asked Apr 13, 2023
424 views
Consider the following relation (capitalized letters are attributes and lower letters are values).X:From the given FDs find the dependencies that seems to apply on X and ...
1 votes
1 votes
1 answer
3
aditi19 asked Jun 7, 2019
1,849 views
How to represent referential integrity constraint in ER model?pls explain with diagram
1 votes
1 votes
0 answers
4
bts1jimin asked Aug 30, 2018
1,271 views