For a tournament to award title norms, it has to have a number of players who are already titled. So your local chess club event won’t do it.
But say you went to one of the big weekend events that offered enough cash to attract titled players. Then you have to play (I think) at least half your games against titled players, and if you achieve a 50 percent score against the grandmasters, that will count as one grandmaster norm.
Better than the American weekend tournaments are the tournaments in Europe that they call “norm tournaments” because they’re conducted mostly in order for players to achieve title norms. In Hungary, they held these things every first Saturday, and called them “The First Saturday” tournaments. How clever.
I forget how many norms are required to earn the title, and they have changed the rules about whether norms expire and the player’s minimum FIDE rating to earn the title.
Those are the technical details. As far as over the board goes, the first step in achieving a title norm at chess is: Get younger, so good luck with that.