I have the following two items which I need to store in dynamodb
The artists have an ID (unique for artists), name and gender. The Songs have an ID (unique for songs), title, genre, artist and rating.
How should I model this in DynamoDB?.
I was thinking about this: ID as the primary key and having a sort key that contains the artist or song so they are distinguished. Is this a good choice? For example, I find I see more variety in the sort key.
What about the field artist in song items? Should I just point to the ID of the artist?