Re: Pizza Example

From: rkc <>
Date: Sun, 04 Apr 2004 18:36:15 GMT
Message-ID: <zAYbc.17$>

"Dawn M. Wolthuis" <> wrote in message news:c4p5td$sck$
> "rkc" <> wrote in message
> news:KjUbc.26386$


> > Really? What would that table look like? A spreadsheet?
> Yes, all of my attempts to look at this through the eyes of an RDBMS
> lead to bunches of "spreadsheets" -- that's the idea, right? The model
> I "think with" isn't in spreadsheet format, but I can pretty much model it
> directly in XML or PICK given that I am not constrained to spreadsheets.
> I missing your point?

My point is that table would have rows with the multivalued columns spread out into multiple columns.

Pizza Size Crust Sauce1 Sauce2 Sauce3 Topping1 Topping2 Topping3

In place of this
Pizza Size Crust Sauce1 Topping1

                         Sauce2  Topping2
                         Sauce3  Topping3

That model is obviously limited.


> If I make it explicit in the spec that there are items that don't have a
> size or crust, would you still drag the "Size" and "Crust" attributes
> with them with NULL values there or would you further normalize this then?
> If so, how?

I don't know now. Are you going to want to track the number of sesame seeds on the sesame seed buns? The ingrediants in the special sauce? Received on Sun Apr 04 2004 - 20:36:15 CEST

Original text of this message