Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    1

    Is this data in 3rd Normal form?

    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

  2. #2
    Join Date
    Dec 2011
    Posts
    6
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •