Definitely. Norman Bates is purely fictional. He was created by authors and has appeared in books, movies, and other forms of entertainment to thrill and scare audiences.
In most cases, Norman is not based on a true story. It's more likely a creation of the writer's mind to entertain and engage the audience with an interesting fictional narrative.
I don't know who the author of 'the book of norman a novel' is. There could be many relatively unknown authors out there with works that are not widely publicized.
The significance of the Tim Norman story depends on what the story is about. If it's a story of how he overcame great difficulties in his life, then it could be significant as an inspiring tale. It might show others that perseverance pays off. However, since we don't know the story, we can only speculate on its possible significance.