Proper normalization for media with multiple types of owners
I am having a hard time deciding on the best way to approach this problem. I am trying to set up an app in rails where users and groups of users can both upload media to albums. The media can be either images or video. I have put together a simple example ERD to show what I have so far https://docs.google.com/file/d/0B8eu...it?usp=sharing.
- What would be the best way to normalize this further?
- Should I separate the video and images into separate tables all together and not link them to the media table?
Any suggestions are welcome.