edited by
23,633 views
10 votes
10 votes

Relations produced from E-R Model will always be in _____

  1. 1 NF
  2. 2 NF
  3. 3 NF
  4. 4 NF
edited by

7 Answers

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. 

Student
SIDSname
1Ram
2Shyam
3hari
SIDPhone no
197772373733
197737377373
297873737337
297686373737

sid and phoneno both form the key in the new relation.

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
2 votes
2 votes

please correct me if wrong

and tell me is sufficient ans to challenge the ans key.

Answer:

Related questions

0 votes
0 votes
5 answers
1
Pooja Khatri asked Jul 13, 2018
2,296 views
In RDBMS, which type of Join returns all rows that satisfy the join condition?Inner JoinOuter JoinSemi JoinAnti Join
0 votes
0 votes
5 answers
3
Pooja Khatri asked Jul 13, 2018
4,673 views
In a Hierarchical database, a hashing function is used to locate the ____CollisionRootForeign KeyRecords