David Macks Destiny trilogy made the Federation president out to be a very powerful position. Easily equivalent to the role the U.S. president has in the U.S. today.
Just for the record, Mack's
Destiny trilogy was taking its cue from previous novels featuring the Federation Presidency, especially
Articles of the Federation by Keith R.A. DeCandido (which focused on Nan Bacco's first year in office), but also, in reverse chronological order before
Articles:
*
A Time for War, A Time for Peace by Keith R.A. DeCandido
*
A Time to Heal by David Mack
*
A Time to Kill by David Mack
And those novels' depictions of the Federation President being akin in power to the US President are taking their cues from the film
Star Trek VI: The Undiscovered Country and the DS9 episodes "Homefront" and "Paradise Lost," which establish extensive foreign policy, military command, and national security powers for the Federation President.
But I was wondering.
To have that much power, would the Fed president have to win a popular vote election by the people of the various planets of the Federation (and how would you ever go about something like that on hundreds of planets?)
Or is the Federation president simply chosen by the Federation Council members? Kind of a "first among equals" situation?
We know from DS9's "Paradise Lost" that the Federation President is democratically elected. We do not know
how he is democratically elected; the canon allows for everything from being chosen by the Council to an indirect election (a la the US Electoral College) to a popular election. However, if he is determined by the Federation Council, one would think he would be the Prime Minister of the United Federation of Planets, since an essential distinction between a President and a Prime Minister is that Prime Ministers are chosen by the legislature from amongst its own members, whilst presidents are independent.
In any even, the novel
A Time for War, A Time for Peace features a Federation special election. It's the first appearance of Nanietta Bacco, then Governor of Cestus III, who runs against Federation Special Emissary Arafel Pagro of Ktar for the presidency. The novel establishes that petitions for candidacy are anonymously submitted to the full Federation Council, which then votes on whether or not the potential candidates meet the specified qualifications for the presidency. (Those qualifications are never enumerated in the novel.) If the potential candidates are approved by the full Council, then they have the option then of accepting or declining candidacy. Upon accepting candidacy, a candidate then campaigns at various locales across the Federation. There's usually at least one debate. A the conclusion of the campaign, there is a popular election that directly elevates the winning candidate to the presidency. Federation elections are massive endeavours that typically take over a week to complete (since every single sentient entity holding UFP citizenship is entitled to a vote), and the results are then audited by two independent firms before the winner is officially certified by the Federation Council.
More data here:
http://startrek.wikia.com/wiki/President_of_the_United_Federation_of_Planets