ookmarks Window Help webcampus.fdu.edu 20 Points) W https://webcam... Logical Data Mo... Question (1) (15+15-30 points) (a) (15 points) You need to draw an ER diagram that is derved from the following requirements: . The collection consists of albums. . An album is made by exactly one artist. . An artist makes one or more albums. . An album contains one or more tracks . Artists, albums, and tracks each have a name. Each track is on exactly one album. Each track has a time length, measured in seconds. . When a track is played, the date and time the playback began (to the nearest second) should be recorded; this is used for reporting when a track was last played, as well as the number of times music by an artist from an album, or a track has been played There's no requirement to capture composers, group members or sidemen, recording data or location, the source media, or any other details of artists, albums, or tracks (b) (15 points) In order that you would implement above ERD and requirements into MySQL database (tables), you need to identify appropriate value of primary key. foreign key, and the value of cardinalibes. Also, Write MySQL code for the ER diagram (part-a) and insert at least five records in each table