CODEWITHSUNDEEP
databasedatabase-designthird-normal-form
rst-2cv
rst-2cv

Reputation: 1180

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

Upvotes: 0

Views: 425

Answers (1)

Hamid Mohayeji
Hamid Mohayeji

Reputation: 4275

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

Upvotes: 1

Related Questions