ER DIAGRAM

Question

Answer 1

I think C) is correct 

one for phone ( phone , dno )

one for office ( office  , dno )

and one for dept  ( dno ,dname )

Comments

@sreshtha if we put  more than one multivalued attribute in  one table if we have to search a particular value of multivalued attribute and get query about particular value in  multivalued attribute then how can this query will be executed , and if it is difficult to run this query then why not this will be put in one table if it will give same problem so i think answer will be 3

http://www.tomjewett.com/dbdesign/dbdesign.php?page=hobbies.php

---

you can write the whole relation Dept into in one table but in that case your primary key will be all the attribute but see there is a underline in Dno means that Dno as primary key so we divide the table split that way , (dno,dname) and (dno,phone,office) .
but in the question if they mention table 2nf form then it will be 3 .

---

-Database systems by Navathe.

So answer should be 3?

Answer 2

(B) option with two tables table u can satisfy this... Dno ------>Dname Dno------>phone office as see obove decomposition is in BCNF..

Answer 3

I think it can be two

first table (dno,dname)

second table (dno,phone,office)  with don,phone,office as key

Comments

That's wt we called relation in bcnf...if we put all the multivalue attributes with all the attributes forming keys....

---

we place multivalued attributes in separate tables to remove redundancy but if these two multi valued attributes are present in the same table then redundancy would be there also.I am confused between 2 and 3.

---

yes redundancy may be possible if we put the multivalued attributes in single table..but the thing is  if we put those two multivalued attributes with key attributes ( d no) than all the three attributes will work as a key to distinguish each and every record of relation.?? 

Answer 4

Answer should be 1. Because we can write it in 1 NF by (Dno Phone Office) as the combined key.