… and another thing (now that I have imported your data).
You should avoid multi-valued columns such as the ‘Works’ column of the ‘Characters’ table. Instead, have a separate table with two columns; CharId and WorkId. This will make it much easier to extract the data.
I am a database professional (of sorts) but not a great expert on Shakespeare.