Welcome Guest, Not a member yet? Register   Sign In
Help with datamapper database design and structure
#3

[eluser]WanWizard[/eluser]
"foods_orders". Both tables names, in alphabetical order, and separated by an underscore.

From a normalisation point of view, there are some question marks.

I don't see why pizza, kebab etc are fields in the main table. What if a merchant introduces sushi tomorrow? Same for "pizza_topping" in food. What if I ordered chinese? Then I don't want toppings, I want prawn crackers and a hot pepper sauce.


Messages In This Thread
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:01 AM
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:33 AM
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:45 AM
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:58 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 07:22 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 07:54 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 10:38 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 10:51 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 11:04 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 04:37 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 07:36 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 09:27 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 10:34 AM
Help with datamapper database design and structure - by El Forum - 04-16-2012, 02:15 AM



Theme © iAndrew 2016 - Forum software by © MyBB