I've got a TV schedule which i need to normalise. I've had a go at it, but am a little unsure whether or not I've got it right. From what I can tell there are no partial dependencies

I think i might need to create so sort of auxiliary attribute for the characters and played by.

What do you think?
http://img338.imageshack.us/img338/6...malisation.png

Thanks

I think what you have is fine assuming:
-A program with a given character never changes actors for that character.
-Two or more programs can have a character with the same name, however since they are different programs the actor may be different for those characters.

If however the same character is always played by the same actor then you would need to create an auxiliary attribute as you said. But in real life, this is hardly ever the case.

If actors change you would need to add the scheduled attribute in your Table3.