Full functional dependencies

Question

Alright I can't seem to wrap my head around the subject normalization.

I have this table

Now I need to find the full functional dependencies.

FilmID, Actor -> Title, Year, Director

Publisher -> PublisherCity

Actor -> DOB, Country

Now Can someone tell me if I'm on the right track? if not then any help would be appreciated.

Answer 1

• Tables
  • fields

I hope this helps:

• films
  • id
  • title
  • year
  • director_id
  • publisher_id

One publisher and director only with this setup.

• actors
  • id
  • name
  • dob
  • country

you missed name from Actor attrs

• films_actors
  • film_id
  • actor_id

This is a join table of films to actors. Allowing you to link limitless actors to films (Many to Many relationship).

• publishers
  • id
  • name
  • city

self explanatory

• directors
  • id
  • name

self explanatory

any questions just ask.