title: Database design
body: <p>I am building a music streaming site, where users will be able to purchase and stream mp3's. I have a subset entity diagram which can be described as follows:</p>
  
  <p><img src="https://i.stack.imgur.com/0Cg1N.png" alt="ER DIAGRAM"></p>
  
  <p>I want to normalise the data to 3NF. How many tables would I need? obviously I want to avoid including partial dependancies, which would require more tables than just album, artist, songs - but I'm not sure what else to add? Any thoughts from experience?</p>