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 392 views answer comment Share Follow See all 8 Comments See all 8 8 Comments reply Mk Utkarsh commented Jul 14, 2018 reply Follow Share 3. 0 votes 0 votes Shubham Shukla 6 commented Jul 14, 2018 i edited by Shubham Shukla 6 Jul 14, 2018 reply Follow Share for which normal form you have not mentioned..?? upto BCNF 2 table needed for 4NF you need 3 as to remove redudancy which exists till BCNF for abve qsn. 0 votes 0 votes Mk Utkarsh commented Jul 14, 2018 reply Follow Share are multi-valued attributes allowed in 1NF? 0 votes 0 votes Shubham Shukla 6 commented Jul 14, 2018 reply Follow Share yeah by coverting them into single valued attribute for example eno ename phone no. 1. ssss 222222/333333 2. bbbb 333222 After converting to single valued 1. sssss 222222 1. sssss 333333 2. bbbb 333222 here phone no. is multivalued attribute.. 0 votes 0 votes Mk Utkarsh commented Jul 14, 2018 reply Follow Share that violates 1NF because now your primary key is duplicated 0 votes 0 votes 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.