Publish Website and Database Project Using Visual Studio

I have asked questions on this issue and I have searched the Internet without much help really.

I just need a direct and clearer knowledge on how to deploy a Website including database using visual studio and also will the database go directly to the server when deploying?