0 votes 0 votes Minimum number of tables required and explain how Iamgveeresh asked Jun 21, 2018 Iamgveeresh 279 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes 3 tables required 1 each for multi-valued attributes "Phone" and "Office" 1 for the main one "Department" Subham Nagar answered Jun 21, 2018 Subham Nagar comment Share Follow See all 0 reply Please log in or register to add a comment.
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. ameen babu chintha answered Jul 24, 2018 ameen babu chintha comment Share Follow See all 0 reply Please log in or register to add a comment.