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 Received on Wed Oct 22 2008 - 19:28:12 CDT