1. Go to SQL Server Management Studio 
  2. Object Explorer 
  3. Databases 
  4. Choose and expand your Database.
  5. Under your database right click on "Database Diagrams" and select "New Database Diagram".
  6. It will a open a new window. Choose tables to include in the ER-Diagram.
  7. Wait for it to complete. Done!!