Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Cocktail Recipe Database Schema - Tables Question - Normalization Expand / Collapse
Posted Wednesday, July 30, 2014 8:48 AM



Group: General Forum Members
Last Login: Yesterday @ 2:44 PM
Points: 16,134, Visits: 16,835
Grant Fritchey (7/30/2014)
Sean Lange (7/30/2014)
[quote]Grant Fritchey (7/30/2014)

Oh how I regret not making my original comment less absolute.

I would never suggest we denormalize our structures in most normal situations for many reasons.

And certainly no need to apologize for calling me to task when I post something so blatantly incorrect.

Ha! Again, apologies. I know I went off on a rant and that was wrong. Maybe I need to step away from the forums for a little while.

Not at all. My comment was flat out incorrect as stated. I have no problem when somebody tells me I am wrong. Nothing you said was snarky or personal at all. You pointed out I was wrong and backed it up with facts. Jeff and Tom also made similar comments about my statement. Keep them coming Grant. We learn more from our mistakes than our successes.


Need help? Help us help you.

Read the article at for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1597781
Posted Wednesday, July 30, 2014 8:57 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 12:49 PM
Points: 660, Visits: 4,532
Think about how you may want to report on or search your data when you consider your categorization, things can go from simple to complicated real fast.

Simple-One category per ingredient. It can be difficult to fit a messy world into a rigid scheme. Is port a wine or a spirit?

Tag Words-You can associate multiple words with a ingredient. Flexible for searching but can get out of control.

Hierarchical-You would need strict data entry and querying becomes more complicated.
Post #1597792
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse