How to ensure each user only answers a question once on the db side?
A unique constraint on Answers (questionid, providerid) was needed, as suggested by Balazs Papp.

As explicitly pointed out by Andriy M this should be a composite key. 

I had to look up composite keys, as I was unfamiliar. Thanks so much to everyone for helping and responding so quickly.