Is it normal to be really scared to have sex for the first time?

You are not at all unique. Don't you think every girl and boy has those same feelings?
Relax, go with the flow and everything will work out exactly the way it is supposed to.