1 votes 1 votes Consider the following ER-diagram for simple database for the National Hockey League given below: The minimum number of table required for database to be in 2NF is ________. Databases er-diagram + – Ashwani Yadav asked Nov 18, 2018 • edited Nov 18, 2018 by Ashwani Yadav Ashwani Yadav 3.3k views answer comment Share Follow See all 14 Comments See all 14 14 Comments reply Show 11 previous comments Prateek Raghuvanshi commented Nov 19, 2018 reply Follow Share @ Ashwani Yadav brother LOGS relation should have weak relation because INJURY RECORD entity is weak entity which means INJURY RECORD entity does not have its own key so have to be merge with relation .so it can identify uniquely .i hope you got my point. 0 votes 0 votes Ashwani Yadav commented Nov 19, 2018 reply Follow Share yes thats true, i was thinking i'm missing some useful information here. you know sometimes in questions we don't get these arrows lines, just single and double lines and i have to consider double line as many side and single line as one side then answer which i got is correct always. I know single line indicates partial participation and double line as total one . but in those questions no info about 1:1 or many to one mapping so considering that way always gives me correct answer. as per this question everything is clear now. Thanks :) 1 votes 1 votes Gate Fever commented Jan 17, 2019 reply Follow Share @Prateek Raghuvanshi even i have this doubt, do we need to check different things if it is asked whether relation is in 2Nf or not?? i mean is the procedure for all BCNF,2NF,3NF same??or different procedure is to be followed?? i mean any special property that needs to be checked?? 0 votes 0 votes Please log in or register to add a comment.