Initial Schema Design

[ShadowXBoss696]

Design the initial database schema structure, which represents all the essential major entities along with required minor entities. ( follow structure from the LastFM API )

Format: ER diagram, UML diagram, or any more suitable one

[ShadowXBoss696]

Draft for the Initial Schema
From my point of view of the above use-case, I designed and implemented this as the initial schema ... Currently we will stick with it until we get a better suggestion

[ShadowXBoss696]

Note - the track album dependency is an optional one and there can be singles not associated with any album. So this does not form any transitive dependency. We will look at optimizing this use case.