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

That works, but since in this scheme Actor is a subset of Person, you don't need two tables.

Clarification: That a Person is an Actor is implied by the fact of their portraying a Character (a Role). Hence, you can collapse Actor into Person, and use a single table.

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