|
An entity-relation diagram (ERD), also referred to as a data model, typically shows the name of each entity, its list of attributes and relationships with other entities. Primary keys can be identified for each entity and foreign keys used to express referencial relationships between entities. Often the data model is later implemented by generating SQL for an RDBMS where entities become tables and attributes becomes columns. Martin's Information Engineering notation is illustrated in the ERD below.
Information Engineering ERD Return to Software Models |