Re: REPORT - DB Design Committee - initial draft
- I will happily replace the Team ID in my database with Lahman Team ID
or Retrosheet Team ID or even create columns for both (except that
would create redundancy....)
--- In firstname.lastname@example.org, "tmasc@y..." <tmasc@y...>
> As well, KJOK DB has a different Team ID than the BDB.
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
- --- In email@example.com, Sean Forman <sean-
> I'm sorry, but I have to ask this. Do you have a reference thatHere's a good primer on key construction. And I should have said, as
> suggests doing this? I'm just not familiar with designing all the
> tables in a DB this way.
this article demonstrates, that it applies to all parent tables,
though you can still argue for all tables in some instances.