Entity Relation (E-R) Diagram and a Sequential Diagram Tips (Tools: SQL Management Stuido, Visual Stuido Architect)
E-R Diagram : Library Check In Check Out E-R Diagram notations in SQL Management Studio or Visual Studio Architect : Understanding following table relationships in a database schema diagram created from either SQL Management Studio or Visual Studio Architect: Unlike other tools like Visio or Erwin, Microsoft uses 'Yellow Key' icon and a '8' or 'oo' icon that are shown at the both ends of a relationship lines connecting two tables . one to one (1:1) : 'Yellow Key icon' in both ends. one to many (1 : 0...*) : 'Yellow Key icon' in one end and '8 icon' in other end many to many (0...* : 0...*) : 'Yellow Key icon' in both ends. Below is an example E-R diagram created for an use ...