DVD+Rental+Normalisation+Solution

Solution

 * Unnormalised Form**




 * First Normal Form**

Note the introduction of a surrogate key as a unique identifier




 * Second Normal Form**

In the relation //**movie**//, the attributes title, director and duration are all dependent on the primary key filmid and not dependent on the compound key of filmid and transaction_number. These 3 attributes must therefore be moved to a new relation.




 * Third Normal Form**

The attributes //**telephone**// and //**email**// are dependent on //**borrower_name**//, so these need to be moved to the new relation: borrower. Also, borrower_name is not a unique identifier, so we have introduced a surrogate key //**borrower_id**//.