databasedatabase-designthird-normal-form

Converting to Third Normal Form


How would you convert this table into Third Normal Form (and what are the resulting tables):

enter image description here


Solution

  • Here are the tables:
    Film (filmNo, fTitle, dirNo)
    Director(dirNo, dirName)
    FilmActor(filmNo, actNo, role, timeOnScreen)
    Actor(actNo, actName)