Airtable might need some work on the rich media front but it's a start for making the idea of relational databases accessible.
If I can offer a suggestion, take a look into ftrack and try to copy some of their core featureset (unless maybe you can already do that, in which case just make a template! ).