How do you normalize one-to-one-or-the-other relationships?

Posted by Jekke on Stack Overflow See other posts from Stack Overflow or by Jekke
Published on 2010-03-23T13:51:17Z Indexed on 2010/03/23 14:13 UTC
Read the original article Hit count: 328

I'm storing data on baseball statistics and would like to do so with three tables: players, battingStats, and pitchingStats. For the purpose of the question, each player will have batting stats or pitching stats, but not both.

How would I normalize such a relationship in 3NF?

© Stack Overflow or respective owner

Related posts about database-normalization

Related posts about normalization