in reply to Re^2: Normalisation Question (OT but trust me, perl implementation)
in thread Normalisation Question (OT but trust me, perl implementation)

Assuming there's a 1:1 relationship between an Episode and its producer, ...

You could assume that, but the cost of being wrong is rather high. By allowing for a 1:n relationship, even if it only happens very rarely, you won't have to rebuild the schema when data arrives about a multi-producer episode.

  • Comment on Re: Re^2: Normalisation Question (OT but trust me, perl implementation)