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.2k views answer comment Share Follow See all 14 Comments See all 14 14 Comments reply Ashwani Yadav commented Nov 18, 2018 reply Follow Share yes, sorry for that, now it is visible. 0 votes 0 votes kumar.dilip commented Nov 18, 2018 reply Follow Share 5 ??? 0 votes 0 votes Ashwani Yadav commented Nov 18, 2018 reply Follow Share No, answer given is 4. can u now explain it to me.? 0 votes 0 votes Prateek Raghuvanshi commented Nov 18, 2018 reply Follow Share Log relation should be weak because of injury record is weak entity. 4 tables are enough- 2 votes 2 votes Ashwani Yadav commented Nov 18, 2018 i edited by Ashwani Yadav Nov 18, 2018 reply Follow Share yes this is correct. but i'm not able to understand why there is extra table for GAME relation.? and also what is the need of saying database to be in 2NF in the question.? 0 votes 0 votes Prateek Raghuvanshi commented Nov 18, 2018 reply Follow Share Guest has different table because guest relation is many to many mapping . 2 votes 2 votes Ashwani Yadav commented Nov 18, 2018 reply Follow Share it is not given in the question. so do we have to assume this by ourselves? 0 votes 0 votes Prateek Raghuvanshi commented Nov 18, 2018 reply Follow Share Yes we have to assume ,arrow line as one and solid line as many 2 votes 2 votes Mayankprakash commented Nov 18, 2018 reply Follow Share @prateek What is the significance of saying 2NF in question. How answer would have changed if they have asked 3NF? THANKS 0 votes 0 votes Prateek Raghuvanshi commented Nov 18, 2018 reply Follow Share Actually All relation are in BCNF .so for 2nf,3nf,bcnf ,4 tables are enough. 1 votes 1 votes Ashwani Yadav commented Nov 19, 2018 reply Follow Share @Prateek GAME relation has both lines as solid lines so it has to be in an extra table, then LOGS relation should also have an extra table as it also has both lines as solid lines with one side as total participation? 0 votes 0 votes 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.