1 votes 1 votes What are minimum number of tables required for the following given ER models such that they satisfy 1NF ? Databases databases er-diagram er-to-relational relational + – Abbas2131 asked Jul 30, 2018 Abbas2131 2.3k views answer comment Share Follow See all 6 Comments See all 6 6 Comments reply Show 3 previous comments arun yadav commented Sep 23, 2020 reply Follow Share 2 1 2 1 2 2 votes 2 votes jiminpark commented Dec 24, 2021 reply Follow Share Can anyone tell what is the correct answer ! Also I am unable to understand questions based on number of tables given ER diagram ( even from the links) Please mention any resource / any way so that we can find the answer to these kind of questions easily! 0 votes 0 votes akshayaK commented Jul 27, 2022 reply Follow Share 2.1.2.1.1 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes A)2 B)3 C)3 D)2 E)2 pradeepchaudhary answered Jan 28, 2019 pradeepchaudhary comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes As Relationship (1:M or 1:1 or 1:N) we require only 2 tables, but there is condition that no multi valued attribute is attached with any entity. But in (M:N) relationship we require 3 tables same condition also holds then it is true. Dharmendra Verma answered Oct 6, 2018 Dharmendra Verma comment Share Follow See all 2 Comments See all 2 2 Comments reply Chandrabhan Vishwa 1 commented Nov 4, 2018 reply Follow Share youwrong on the case of1:1 because if both side partial participation then the number of table is 2 0 votes 0 votes vinay chauhan commented Nov 10, 2018 reply Follow Share Please refer to https://gateoverflow.in/77410/doubt for correct explanation 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes 2 1 2 1 2 chandan sahu answered Dec 3, 2018 chandan sahu comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Answer will be 2 3 3 1 1. 91Arpita answered Jul 18, 2019 • edited Jul 18, 2019 by 91Arpita 91Arpita comment Share Follow See all 0 reply Please log in or register to add a comment.