Welcome Guest, Not a member yet? Register   Sign In
Database Design Help
#6

[eluser]wiredesignz[/eluser]
[quote author="Crafter" date="1191867351"]
From a common sense point of view, yes.

From the provided database structure, no.[/quote]

The database structure is faulty.

What happens to Plans if a Provder is removed from a State?

Plans are a business entity belonging to Providers they have no direct relationship to State so state_id should not feature in the Plans table.

Providers may also have branch offices in each State, so a relationship for different provider details must also be established.

@obiron2

Also having to do a "SELECT DISTINCT" in this case means you haven't normalized your tables properly.


Messages In This Thread
Database Design Help - by El Forum - 10-07-2007, 04:22 PM
Database Design Help - by El Forum - 10-07-2007, 07:06 PM
Database Design Help - by El Forum - 10-08-2007, 03:34 AM
Database Design Help - by El Forum - 10-08-2007, 07:15 AM
Database Design Help - by El Forum - 10-08-2007, 08:45 AM
Database Design Help - by El Forum - 10-09-2007, 05:05 PM



Theme © iAndrew 2016 - Forum software by © MyBB