Entity relationship diagram design


An entity relationship diagram (ERD), also known as an entity relationship model, is a graphical representation that depicts relationships among people, objects, places, concepts or events within an information technology (IT) system.


How to go about creating an ER diagram.
  1. Identify all the entities in the system. An entity should appear only once in a particular diagram. 
  2. Identify relationships between entities. Connect them using a line and add a diamond in the middle describing the relationship.
  3. Add attributes for entities.

 

Comments

Post a Comment

Popular posts from this blog

Data analysis in Excel

Image
 Ideas in Excel is now Analyze Data To better represent how Ideas makes data analysis simpler, faster and more intuitive, the feature has been renamed to  Analyze Data . The experience and functionality is the same and still aligns to the same privacy and licensing regulations. If you're on Semi-Annual Enterprise Channel, you may still see "Ideas" until Excel has been updated.  
Read more