[Data-modeling] TV sub-episodes

[Christopher R. Maden]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jeff Prucher wrote:
> This would potentially result in a denormalization of sorts, since
> the list of people involved in a show comprising multiple segments
> should be the union of the list of people for each segment. I think
> we can live with this, but it might look a bit odd to some people.

Can delegation be used?  Although a segment is not an episode, I do not
think it is in any way misleading to say that the Dead Parrot Sketch has
a /tv/tv_episode/producer of ... .

> I'm also not convinced that "segment" is the right term, since news
> programs (for example) can be organized into things called segments
> that are different than what I'm trying to model.

I think that the term of art for news shorts, comedy shorts, and variety
shorts is the same; I don’t have a problem with that.  And a news
segment may well have a distinct director from the director of a
half-hour news broadcast taken in toto.

~Chris
- --
Chris Maden, text nerd  <URL: http://crism.maden.org/ >
“All I ask of living is to have no chains on me,
 And all I ask of dying is to go naturally.” — Laura Nyro
GnuPG Fingerprint: C6E4 E2A9 C9F8 71AC 9724 CAA3 19F8 6677 0077 C319
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkoOHL0ACgkQGfhmdwB3wxknPwCgyPf9ag/+O+gnwUSB5HTC3Xq4
8XgAnA5/mdcuqDzdV82mHeXQ0zoCz8g0
=pUyR
-----END PGP SIGNATURE-----