1 1 vote I had some doubts regarding Miniumum number of tables. Can anyone answer the above question? Databases + – Ashish Kumar Choubey 680 views answer comment Share Follow Print See all 4 Comments 4 4 Comments reply gauravkc commented Jan 28, 2018 reply Follow flag 3 3 ? 0 0 replyShare Sidd_ commented Jan 28, 2018 reply Follow flag For 1nf design 1st er diagram would have min. 2 tables 2nd would have min. 1 table. 0 0 replyShare Ashish Kumar Choubey commented Jan 28, 2018 reply Follow flag This is the answer given my Made Easy people. But I cannot understand how 2 is the answer 0 0 replyShare Ashish Kumar Choubey commented Jan 28, 2018 reply Follow flag @sidd_ Your answer for the first one is correct(according to Made Easy people). Will you please elaborately explain the reasons? As far as the second question is concerned, you are saying that we require one table for 1NF. But if we take one table they what will the candidate key be? Please explain this also 0 0 replyShare Please log in or register to add a comment.
1 1 vote both have 3 as answer. Whenever the cardinality of both the entity type is more than 1 . We make another table containing the primary keys for both the tables. same goes for 2. therefore we have 3 tables two original and one containing the keys. akash gosain answered Jan 28, 2018 akash gosain comment Share Follow See 1 comment 1 1 comment reply Ashish Kumar Choubey commented Jan 28, 2018 reply Follow flag I am aware of the rule that you mentioned. But Made Easy Test people say that the answer is 2. Check the comment on the question for the reason that they give 0 0 replyShare Please log in or register to add a comment.
