2 votes 2 votes superask asked Jan 3, 2017 superask 9.8k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
3 votes 3 votes Seperate tables required for multivalued attributes. hence for 1NF 4 tables required. I am not sure about BCNF but i think it will be 4 tables too.. 4Nf is not in syllabus right so i don't have idea about.. S Ram answered Jan 3, 2017 S Ram comment Share Follow See all 4 Comments See all 4 4 Comments reply superask commented Jan 3, 2017 reply Follow Share only 1 table is the answer in the answer key according to made easy... 0 votes 0 votes S Ram commented Jan 3, 2017 reply Follow Share for 1nf??? but how can multi values allowed ??? if they have given any explanation about? 0 votes 0 votes superask commented Jan 3, 2017 reply Follow Share I also think that answer should be 4 for all the cases.But in the answer key given by made easy faculty is 1, 2 and 4 respectively. 1 votes 1 votes Na462 commented Oct 18, 2017 reply Follow Share Sir You gave answer as 4 tables because Employee name is composite so it can be decomposed into first name,middle name and last name so separate table for each and one table for the Entity itself Right? 0 votes 0 votes Please log in or register to add a comment.