10 votes 10 votes Relations produced from E-R Model will always be in _____ 1 NF 2 NF 3 NF 4 NF Databases databases er-diagram database-normalization ugcnetcse-july2018-paper2 + – Keith Kr asked Sep 25, 2014 • edited Jun 24, 2019 by Satbir Keith Kr 23.8k views answer comment Share Follow See all 3 Comments See all 3 3 Comments reply Shaik Masthan commented Jul 25, 2018 reply Follow Share it should be 1NF because composite attributes need to convert into Simple attributes, 0 votes 0 votes himgta commented Aug 10, 2018 reply Follow Share Can anyone explain this question in more detail? 0 votes 0 votes kumar.dilip commented Oct 29, 2018 reply Follow Share 1 NF. 0 votes 0 votes Please log in or register to add a comment.
18 votes 18 votes 1 NF.Simple atomic values non multivalued attributes.Generally ERD is design level task and Relational model is implementation. Whenever relational model is implemented from erd we get rid of multivalued attribute. The procedure is outlined here: http://web.cse.ohio-state.edu/~gurari/course/cse670/cse670Ch9.xht. Multi-valued attributes are removed as M:N binary relation by repeating the tuples and hence relation becomes 1NF. We cannot guarantee any higher normalization. StudentSIDSname1Ram2Shyam3hariSIDPhone no197772373733197737377373297873737337297686373737sid and phoneno both form the key in the new relation. Jarvis answered May 28, 2015 Jarvis comment Share Follow See all 2 Comments See all 2 2 Comments reply amarVashishth commented Jul 25, 2015 reply Follow Share link is not working 0 votes 0 votes Sankaranarayanan P.N commented Jan 5, 2018 reply Follow Share in the given example above both relations are in BCNF right? there is no partial dependency between non prime attribute and key there is no transitive dependecy between non prime attribute and key through a non prime attribute for every non trivial fd X --> A, X is a super key of the relation 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes there is no answer to this question condition for a relation from e-r model is that it should not have a complex attribute(like address) but relation from er model could have complex attribute my guess would be a.1NF Aravind answered Sep 25, 2014 Aravind comment Share Follow See 1 comment See all 1 1 comment reply Rajarshi Sarkar commented May 23, 2015 reply Follow Share What if multi valued attributes are present? Won't be 1 NF then! 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes E-R MODEL RELATION CONTAINS 1NF arun_singh answered Jul 13, 2018 arun_singh comment Share Follow See all 0 reply Please log in or register to add a comment.
2 votes 2 votes please correct me if wrong and tell me is sufficient ans to challenge the ans key. pream sagar answered Jul 26, 2018 pream sagar comment Share Follow See 1 comment See all 1 1 comment reply PallabiC commented Jul 31, 2018 reply Follow Share this should be in 1NF. And the revised answer key also says wrong. 0 votes 0 votes Please log in or register to add a comment.