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

in reply to Re: 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, the extra table for PersonProducesEpisode is not necessary. You can instead model an Episode as (episode_id, episode_producer, episode_details) where episode_producer is a foreign key to Person.

Makeshifts last the longest.

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

Replies are listed 'Best First'.
Re: Re^2: Normalisation Question (OT but trust me, perl implementation) by dws (Chancellor) on Aug 05, 2003 at 16:14 UTC
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.	[reply]

In Section Seekers of Perl Wisdom