How to create a Software application

There has been lot of discussion on how a Software application should be developd.

What should be the Architecture?
What can be the best framework?
What should be the design?
What design principles can be applied?
How to cater to always changing requirements?
How to for-see a requirement?
Which database to use?