[Data-modeling] TV sub-episodes

[Gordon Mackenzie]

I would call these 'scenes' A scene is the most basic element of most TV/theater productions...That's what I remember from my acting days. Scenes make up an act, acts make up a play/teleplay/episode. 

A notable 'scene' would be like the specially-directed-by-guest-director Q. Tarantino, the night drive to the tar pit with Clive Owen having a very strange conversation with the dead man talking, Benicio del Toro. 


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
- --