I read about database diagram and normalization, So I have managed to follow the normalization rules. But I am not sure if this is right or not ?

enter image description here

What my database should do:

I want to add posts which will consist multiple question and answers, which will be of specific chapter in a book.

closed as too broad by MDCCL, mustaccio, Michael Green, hot2use, LowlyDBA Feb 11 at 13:50

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 2
    Do you actually have a programme which works against this data structure? That's the ACID (in both senses of the term) test! – Vérace Feb 9 at 11:20
  • 2
    Can't judge a schema without seeing the SELECTs that will be used. – Rick James Feb 9 at 16:20
  • 2
    A diagram should be a representation of the relevant business rules (AKA "the conceptual schema"); so, in order to know if it is "good" or not (from a representational point of view), you should disclose the corresponding business rules. – MDCCL Feb 9 at 21:17
  • 2
    It's good. I like the colours. – mustaccio Feb 9 at 22:58
  • 1
    Could do with more cerulean. Contours are very round. – danblack Feb 11 at 5:00