Indicate what is the normal form of this table and why? And convert it to 3rd...

 

Transcribed Image Text:

Indicate what is the normal form of this table and why? And convert it to 3rd normal if it is not in the third normal form. Table ADDRESS MembershipID 1 2 3 Table: MOVIE MembershipID 1 2 FullName Janet Jons Robert Hill Robert Hill Address 20, Bulbourn Road 5th Street 8 Pine Valley MovieRented Clash of the titans Pirates of the Caribbean Daddy's little girls ADDRESS (MembershipID PK, FullName, Address, Salutation) MOVIE (MembershipID FK,MovieRented) Salutation Ms Mr Mr Indicate what is the normal form of this table and why? And convert it to 3rd normal if it is not in the third normal form. Table ADDRESS MembershipID 1 2 3 Table: MOVIE MembershipID 1 2 FullName Janet Jons Robert Hill Robert Hill Address 20, Bulbourn Road 5th Street 8 Pine Valley MovieRented Clash of the titans Pirates of the Caribbean Daddy's little girls ADDRESS (MembershipID PK, FullName, Address, Salutation) MOVIE (MembershipID FK,MovieRented) Salutation Ms Mr Mr