Could be made closer to normal form?

Love the project.

I suspect it would be better and easier to work with, if you used ChapterID as an indexed column within Paragraphs to establish the relation to chapter, instead of 'duplicating' this information in the Chapter table, hence avoiding the requirementfor a joint index across the Act and Scene columns for requests to be efficiently handled in the Paragraph table.

This isn't a bad reference for thinking about these design decisions.
https://en.wikipedia.org/wiki/Database_normalization