Entity Relationship Diagram. An entity relationship model, also called an entity-relationship (ER) diagram, is a graphical representation of entities (which will become your tables) and their. Entity Relationship Diagram (ERD): Basics J.G. Zheng Fall 2010 CIS 3730 Designing and Managing Data. Overview: 3 Level Database Design Creating an Entity Relationship Diagram (ERD) and associated data dictionary to represent the reality and capture business data requirements.
I really need some advice on how to go about tackling an entity relationship diagram. I have to design one based on an application and have to show the cardinality and optionality of each relationship which I identify. I understand what this means and have looked over some examples on this but I am finding it hard to relate what I have got. The entities which I have identified so far are: Client, Application, Reports, Interfaces
Also, what is the standard (if there is one) for representing Application, Business, Interface(s), etc. layers in a diagram?