Yes, I believe it’s normal.
Although I am younger than you (23), I have or had more or less the same problem like you.
I was so devastated after 3 attempts. I felt so bad and heart broken and I just couldn’t face the girl any more. I was so into her and just couldn’t hang around her any more. I felt very uncomfortable and also nervous in her presence. I was also scared of getting jealous should in case the girl started dating another guy…
As flyingfish rightly said, we are facing these problems because we haven’t yet found an alternative. Personally, I don’t have some many female friends so that particular girl kind of meant everything to me.
So a possible solution is to associate and make friends with other girls/women.
A much better solution which I am now putting into practice is to leave everything in the hands of the Lord. God has a plan for all of us and often times; we try to take control of this plan.
I bought some books written by Jason Evert about relationships and Purity. I am still reading them but so far, they have been very helpful. This is a quotation from the book Purity 365 (which is more or less a collection of quotations)
To love at all is to be vulnerable. Love anything, and your heart will certainly be wrung and possibly be broken. If you want to make sure of keeping it intact, you must give your heart to no one, not even to an animal. Wrap it carefully round with hobbies and little luxuries; avoid all entanglements; lock it up safe in the casket or coffin or your selfishness. But in that casket–safe, dark, motionless, airless–it will change. It will not be broken; it will become unbreakable, impenetrable, irredeemable. – C.S. Lewis
I also read that we shouldn’t let our happiness be determined by other people. That as singles, we should learn to be happy and this can come about by seeking God’s love. As such, we wouldn’t need to rely on females to make us happy (and vice versa). The fact is that, God has a plan for all of us and we should always remind ourselves of that.
You could find some very useful information on the chastity website: chastity.com/chastity-qa/dating/dating
Another thing we have to understand is that each person has an ideal man or woman and not everybody is ready for anything less than that. So sometimes if the other person is not interested in a relationship, one just has to respect that decision and move forward.
As for me, I am almost completely over the girl and I am ready to associate with her again and take her as a normal friend (I will tell her that on Easter Sunday). I strongly believe I will find the girl God has chosen for me and I am training myself to be joyful and happy as a single young adult.
I wish you all the best. Just take and accept the soprano as a friend and move forward.
PS: Note the difference between love and attraction/feeling. Our desires are mere attractions and not love. Love is a decision and that’s what God requires from us. So we should avoid brooding over attraction.