279 views

2 Answers

0 votes
0 votes

3 tables required

1 each for multi-valued attributes "Phone" and "Office"

1 for the main one "Department"

0 votes
0 votes
If an entity contains set of multi-valued attributes then we have to decompose the relation into 2 relations.
1)relation contains key with simple attributes
2)relation contains key with multivalued attributes.
So, answer is 2.

Related questions

0 votes
0 votes
0 answers
2
Usama2112 asked Jan 1, 2023
417 views
Entity-relationship and Relational Model:el:Convert the following entity-relationship diagram into tables of relational model
2 votes
2 votes
2 answers
4
abhishek tiwary asked Nov 17, 2017
386 views