[x] can a photo have more than one tag? If that is the case you'd need to remove the tagId from the photos table and instead have a join table between photos and tags.
[x] Remove the commentId from the photos table, the comments table has a photoId which will implement the one to many relationship between photos and comment
[x] Remove photoId and userId from the tags table, a tag shouldn't belong to a user as it is applied to photos and you want a one to many (tag to photos) that's why you don't need the photoId in the tags table.
[x] Add a name to the albums table, remove the photoId, what you want is an albumId in the photos table so that one album can have many photos. I didn't see this feature in the MVP list, I would add it as a bonus.
Hi Malik, here are some comments about your docs:
DB schema: