"Mike Raiford" <"m[raiford]!at"@gmail.com> wrote in message
news:4a7b1abd$1@news.povray.org...

> Oh, and get this... the database is just as delightful. The customer's
> address information is in..... 3 tables.
>
> 1 the main table contains the address itself, and pointers to the city,
> and the state tables.
>
> That's right, a row for every city, and a row for every state.

It sounds bad: The city table should include a foreign key to the state
table instead of main table referencing both. Better yet, there should be a
street table that actually points to the city table which points to the
state table. <g>

Post a reply to this message