2 votes 2 votes Databases er-diagram databases + – Nils asked Nov 14, 2017 Nils 419 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes Ans : 2 in case of 1NF 1 For E1 1 For E2 &R (Because in 1NF values should be atomic & no multivalued entry should be allowed.) Ans : 3 in Case of 3NF 1 for E1 1 for E2 1 for R ( because its m:n relationship) So 3 yogi_p answered Nov 14, 2017 edited Nov 15, 2017 by yogi_p yogi_p comment Share Follow See all 2 Comments See all 2 2 Comments reply Nils commented Nov 14, 2017 reply Follow Share but the in solution is 2 they combine R & E2. 0 votes 0 votes yogi_p commented Nov 15, 2017 reply Follow Share Yeah , your point is right. They would be combined in case of 1NF Check the Corrected ans 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes Two tables: E2R : D, E,F, A (FK to E1) E1: A, B, C akshat sharma answered Nov 14, 2017 akshat sharma comment Share Follow See all 0 reply Please log in or register to add a comment.