1 votes 1 votes 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?? Databases er-to-relational + – G Shaheena asked Jul 14, 2018 G Shaheena 363 views answer comment Share Follow See all 8 Comments See all 8 8 Comments reply Show 5 previous comments Shubham Shukla 6 commented Jul 14, 2018 i edited by Shubham Shukla 6 Jul 14, 2018 reply Follow Share 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. 0 votes 0 votes Shaik Masthan commented Jul 14, 2018 reply Follow Share @Shubham Shukla 6, what about 2NF ? there exist PFD's right ? 0 votes 0 votes Shubham Shukla 6 commented Jul 14, 2018 reply Follow Share @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..! 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes 3 table is required. abhishekmehta4u answered Jul 14, 2018 abhishekmehta4u comment Share Follow See all 0 reply Please log in or register to add a comment.