1 votes 1 votes Given answer is 2, but I think that for each multivalue attribute we need a relation and one for the main entity, therefore 3 should be the answer. Please correct me if I am wrong Databases databases er-diagram + – shikharV asked Dec 8, 2015 shikharV 2.7k views answer comment Share Follow See 1 comment See all 1 1 comment reply LeenSharma commented Dec 8, 2015 reply Follow Share yes 3 should be Answer. 0 votes 0 votes Please log in or register to add a comment.
Best answer 10 votes 10 votes Minimum Table require 1NF = 1 table (Dno Dname Phone Office) BCNF = 2 table (Dno Dname) (Dno Phone Office) 4Nf = 3 Table for each MVD one table (Dno Dname) (Dno Phone) (Dno Office) Umang Raman answered Dec 8, 2015 selected Dec 8, 2015 by shikharV Umang Raman comment Share Follow See all 21 Comments See all 21 21 Comments reply Show 18 previous comments Venkat Sai commented Dec 31, 2017 reply Follow Share yes bro as it asked for minimum we get 1 table we don't need to care about redundancy in 1NF we just need to care about atomicity Being able to uniquely identify a row (tuple) is a requirement of 1NF. the article u gave says this after normalization keys can change that's not a problem in worst case all the set of attributes also can form the key generally when we create a seperate table for multivalued attributes we have the primarykey+multivalued attribute as a key for the new table 0 votes 0 votes reena_kandari commented Jan 4, 2018 reply Follow Share how you all can consider a table without a PK? PK should be there for each and every tables without this making tables makes no sense . 0 votes 0 votes Venkat Sai commented Jan 4, 2018 reply Follow Share the entire schema can be taken as a key as no to tuples are same we can identify each tuple uniquely with that 1NF only thinks about the composite attributes and multi-value attributes hence we don't need to think about redundancy 0 votes 0 votes Please log in or register to add a comment.