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.
sid and phoneno both form the key in the new relation.
What if multi valued attributes are present? Won't be 1 NF then!
Relations produced from an E-R model will always be in 3NF
Answer is C
naga praveen can you please explain ?
There is one more problem. Ppl who have...