Given the original relation and functional dependencies, normalize the original and all resulting relations to 2NF. Be sure to use proper relational notation: RELATION(pkattr, attribute, fkattr). Include reference statements for foreign keys.

Problem #3 MOVIE studio star length 124 Fox Fox 124 124 117 C. Fisher M. Hamill H. Ford Fox Paramount Paramount S. Weaver title year Star Wars 1977 Star Wars 1977 Star Wars 1977 Alien 1979 Aliens 1986 Alien3 1992 Annie Hall 1977 Annie Hall 1977 Chaplin 1992 Dr. Strangelove (1964 Restoration 1995 137 113 type Color Color Color Color Color Color Color Color B&W B&W Color 93 93 124 Paramount Warner Bros Warner Bros MGM Paramount Miramax S. Weaver S. Weaver W. Allen D. Keaton R. Downey R. Torn R. Downey 93 117 MOVIE(title, year, length, type, studio, star) Functional Dependencies: title, star year, length, type, studio title year, length, type, studio