Question: Please help with Normalization! EXERCISE 2 NORMALIZATION (100) Table 2 contains information from the music app. The users of this app can listen to different
Please help with Normalization!

EXERCISE 2 NORMALIZATION (100) Table 2 contains information from the music app. The users of this app can listen to different songs by various artists. A user can assign a numeric rating between 1 and 5 to any song they want. Table 2 Music App data Song Song Name User ID Artist ID Artist Vote User Name ID User Residence State Name value 1234 | Jim GA 11 3456 Led Zeppelin Led Zeppelin Sally TX Stairway to Heaven Stairway to Heaven Hit the Road, Jack Hit the Road, Jack Change 1234 Jim GA Ray 3456 Sally TX wNNl- Charles Ray Charles Taylor Swift 6789 Lisa WA E2.4 Using one of the two notations discussed in class, depict full key functional dependencies (if any), partial functional dependencies (if any), and transitive functional dependencies (if any) in the Table 2. E2.5 Is Table 2 a relational table? Briefly explain why or why not. Make any necessary changes to convert Table 2 to 1NF (if such changes are needed) otherwise attach the copy of the original table with no changes. E2.6 Show the result of normalizing the Table 2 to 2NF. You need to attach screenshots of the tables resulting from normalization to 2NF. E2.7 Show the result of normalizing the Table 2 to 3NF. You need to attach screenshots of the tables resulting from normalization to 3NF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
