Re: Few confusing things about first normal form

greetings

I realize that the arguments you gave here basically also answered my
first question in another thread. But with regards to my second
question in that other thread, your argument here is also that SQL
doesn’t allow multi valued attributes. But if we limit our discussion
just to the theory, then multi valued attributes can exist. Thus table
( where ITEM column holds multiple values ) in my second question

ORDER ( ORDER_ID, ITEM )

is not normalized and as such the question is still valid?


If you expect to learn these concepts from miscellaneous web sites then you
will come to grief. Get a decent text by a respected author such as:
http://www.amazon.com/Introduction-Database-Systems-8th/dp/0321197844

I only visit those sites if I don’t completely understand what my book
is trying to convey ( which admittedly happens alot ).

I'm also unfortunatelly stuck with the book ( long story ) I have and
need to understand everything in it

thank you kindly
.

Relevant Pages
Loading