Question: Qn 3 . Normalise the following relation to remove modification anomalies showing all steps for 1 NF , 2 NF , and 3 NF .
Qn Normalise the following relation to remove modification anomalies showing all steps for NFNF and NF State any assumptions necessary to support your answer. Provide appropriate justification for each normalisation step.MovieRentalcustNo custName, custPhone,movieID, movieTitle, releaseYear, numberInStock, rentalDateIn rentalDateOut,rentalAmountFunctional dependencies:custNo custName, custPhonemovieID movieTitle, numberInStock, releaseYearcustNo, movieID rentalDateIn rentalDateOut, rentalAmountPrimary key: custNo, movieID
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
