View Single Post
Old March 26th, 2008, 10:56 AM
woodyz woodyz is offline
Friend of Wrox
Join Date: May 2006
Location: San Diego, CA, USA.
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts

quote:Originally posted by mmcdonal
 E.F. Codd would say that the table tblCustomers does not even meet 1NF since it lacks atmoicity.

FullName should be FirstName and LastName,

possibly Salutation, FirstName, MiddleNameorInitial, LastName, Suffix


Look it up at:
I don't know what Codd would say, but I disagree. If the full name is sufficient for the abstraction of what the application expects from a customer entity, then it is atomic. For example, would this be an atomic StreetAddress field:
"1234 Grand Ave."
Or would you have to break it into AddressNumber, AddressStreetName, and AddressStreetExtenstion?

In other words, it depends on the meaning of the data, and that cannot be determined by merely looking at the data in a field, but requires knowing the domain of the application.

Woody Z
How to use a forum to help solve problems
My blog... please visit