Rework the relation interface to be more flexible and robust

[dstathis]

After discussions about how database relations should request new databases, I have reworked the charm library.