Many people have, over the years, both in the blog comments and in private messages, objected to my contention in the Normal Forms tutorial that ITEM_PRICE leads to failure of Second Normal Form. I always go back and forth about this, and I generally tell people something like “it depends on the business rules, it’s not a matter for Normalization to solve, I wanted to keep things simple,” etc. Enough people have pointed this out that I finally decided to spell out the problem in the tutorial itself, under the NF2 discussion. Hopefully this will not prove too confusing for beginners, while at the same time keep the advanced readers satisfied!
-
Recent Posts
- Lord Matthew’s Honor
- Bublick, the Name
- Alvin’s Ashes
- A Tale of Two Houses
- The Daring Mr. Melling
- An Unlikely Farmer
- Julia Swedish Was Not Swedish!
- Finding the Family Farm
- Kay’s 48 in Gay Paree
- Happy Great-Grandmother’s Day
- Love, Yorkshire Style
- Nat Griffin’s Draft Card
- Finding Grandma
- The Irish Connection, Part 2
- The Irish Connection
- Private Frank Elliott, 1897-1917
People I know