Re: Scotty and his military comment
I'll just point out that Starfleet does build ships for fighting, even in the 24th century...
1. Galaxy-class (stardrive section with "battle" bridge)
2. Defiant-class (developed to fight the Borg)
3. Prometheus-class (multi-vector assault mode)
"...the most elementary and valuable statement in science, the beginning of wisdom, is I do not know." - Lt. Commander Data, "Where Silence Has Lease"