Diff between WFE,applicationserver,database server in Sharepoint

 

These what are called server roles, all can be on the physical Server or can be on multiple servers.

WFE Role hosts SharePoint site and handle user requests,
Database Role hosts and manage SharePoint databases,

Application Role can host some services like Excel, Forms