583 views
0 votes
0 votes
if there is one to many relationship from entity set A to B; B has simple primary key and a multivalued attribute, then min no. of tables satisfying 3NF?

1 Answer

1 votes
1 votes
4 tables 2 for entity one for relation one additional for multivalueed attribute

Related questions

0 votes
0 votes
0 answers
1
Usama2112 asked Jan 1, 2023
417 views
Entity-relationship and Relational Model:el:Convert the following entity-relationship diagram into tables of relational model
1 votes
1 votes
2 answers
2
Srken asked Nov 12, 2021
1,586 views
I think it needs three tables but have lil bit confusion
0 votes
0 votes
1 answer
3
aoao asked Sep 26, 2018
2,427 views
The Answer is 3. But I think only 2 are required as R2 is many(E3) to one(E1) with total participation.Thus tables formed E2R1(DFA) with pk as DA. R2(GHABC) with pk as G....
2 votes
2 votes
3 answers
4
daksirp asked Apr 23, 2022
1,313 views
What is the cardinality of this relationship? is m-n cardinality correct? if not, why?