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 User Name Artist ID Artist Name Vote value User Residence State GA 1234 Jim 4 11 3456 Sally | TX Stairway to Heaven Stairway to Heaven Hit the Road, Jack Hit the Road, Jack Change 1234 Jim GA TX Led Zeppelin Led Zeppelin Ray Charles Ray Charles Taylor Swift 3456 Sally 2 6789 Lisa WA E2.1 Using the relation presented in the Table 2, describe in one sentence an example that illustrates the insertion anomaly. E2.2 Using the relation presented in the Table 2, describe in one sentence an example that illustrates the deletion anomaly. E2.3 Using the relation presented in the Table 2, describe in one sentence an example that illustrates the modification anomaly. 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 INF (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