did that character have relationships with many women?
Yes, he is married to Claire and has a sexual relationship with Zoe.
Frank Underwood (House of Cards)
He is married to Claire Underwood (Robin Wright), and also had a sexual relationship with Zoe Barnes (Kate Mara) 
what happens to frank underwood in house of cards He becomes the President of the United States and then gets murdered in the last season. who is frank underwood? A fictional character and the protagonist of the American adaptation of "House of Cards" which actor plays that character? Kevin Spacey. how were his character and personality depicted in that adaptation? He is shown as a ruthless politician who rises to power through  treachery, deception and murder.
wiki:18675370
Frank Underwood (House of Cards) [SEP] Introduction
Francis Joseph Underwood is a fictional character and the protagonist of the American adaptation of "House of Cards", portrayed by Kevin Spacey. He is depicted as a ruthless politician who rises from House Majority Whip to President of the United States through treachery, deception and murder. He is based on Francis Urquhart, the protagonist of the British novel and television series "House of Cards", from which the American Netflix series is drawn. He is married to Claire Underwood (Robin Wright), and also had a sexual relationship with Zoe Barnes (Kate Mara) in season 1. He made his first appearance in the series' pilot episode, "Chapter 1".