# ER diagram

Question

Consider an entity department has attributes dno, dname, phone, office where dno is key and phone and office both are multivalued attributes then minimum no of tables required??

Comments

yeah for 1NF key would be eno,phoneno. than it would be in 1NF

for 2NF,3NF,BCNF 2 tables required.

As 4NF allow only one multivaled attribute in table so you need to make 3 tables for 4NF.

---

@Shubham Shukla 6,

what about 2NF ? there exist PFD's right ?

---

@shaik yes i did not see that dname also there...so 2 table required to be in 2NF..one dno,office,phone table with all 3 combined as candidate key and other table    dno.dname with dno as candidate key..!

Answer 1

3 table is required.