I believe CowperKettle's answer is correct, but perhaps not clear, given the number of follow-on questions. Let me try to phrase it a different way and see if this helps.
Normally, we do not use an article with a proper noun. "Regini was the center of attention", NOT "The Regini was the center of attention."
An exception to this -- the only exception that I can think of -- is when the proper noun is used with a qualifying adjective or descriptive phrase.
Sometimes an adjective is attached to a person's name almost as a title, like TRomano's examples of "The Great Houdini" and "The Unsinkable Molly Brown". Note that if it really IS a formal title, like "king" or "president", we don't use an adjective. "King John signed the Magna Carta", NOT "The King John ..."
But if you added an additional adjective that was not part of his formal title, then you would use an article. "The famous King John signed the Magna Carta."
The adjective can be a single word like that example, which normally precedes the noun, or it can be a descriptive phrase, which normally follows the noun. "The beautiful and talented Sally Jones ..." "The Sally Jones who is beautiful and talented ..."
Sometimes the adjective simply describes the person. Often we use it to distinguish the person from some other person with the same name. For example, "No, not the George Washington who was president, the George Washington who is in our math class." Or similarly, to distinguish a person at different times in his life, or different aspects of his personality. "I want to see the old Brenda again, the Brenda who was fun and romantic. I'm sick of the Brenda who is boring and nasty."
Note that an article is used when there is an "ordinary adjective", but not a predicate adjective. For example, we say, "Harold is tall", no article. But "The tall Harold entered the room", yes article. That is, when the sentence is simply stating that a person or object has this attribute, using a word like "is" or "seems" or "becomes", we don't use an article. But when the description is attached to the person in the course of saying that he did something else or something else was done to him, then we do use the article.
Let me add that the article in such a case is usually "the", but not always. And all my examples have used people, but you could use anything that is identified by a proper noun. Like, "I remember an America very different from the country we know today."
1If Ragini is a girl's name, then it should not be preceded with "the". – Tᴚoɯɐuo – 2014-10-04T17:01:12.593
@TimRomano but it does not follow Wren & Martin's book explanation – Tarun – 2014-10-04T17:25:37.960
2Incorrect, @Tarun. ...when it's qualified by an adjective or defining adjectival clause. The Great Houdini. The one and only Tarun. The unsinkable Molly Brown. – Tᴚoɯɐuo – 2014-10-04T17:30:26.390
@TimRomano As per book this sentence is also correct "The Mr.Roy whom you last met last night is my uncle". – Tarun – 2014-10-04T17:54:02.000
2This example assumes a conversation that went along these lines: Joe: "I went to the party with my cousin, Rob Roy." Mike: "Is that the Mr Roy I met last night? He seemed rather old to be your cousin." Joe: "No. The Mr Roy you met last night is my uncle, Rob's father." – Tᴚoɯɐuo – 2014-10-04T19:39:20.723