Microsoft SQL Server vs. SQL Server Management Studio

Question

What is the difference between Microsoft SQL Server and SQL Server Management Studio (SSMS) and how can I integrate SSMS in Visual Studio 2012 so I can use database diagrams?

Answer 1

Credit to marc_s:

SQL Server = database engine; SQL Server Management Studio = GUI Administration Tool for working against the SQL Server engine

Answer 2

It seems like Microsoft is trying to make SSMS look like Visual Studio, but there is still no integration. Use the Entity Framework 6.0 within Visual Studio 2012 to generate those diagrams for you.

Download here: Entity Framework 6.0