page_title: Database design
section_title: ER diagram (entity-relationship model)
hierarchical_section_title: Database design / ER diagram (entity-relationship model)
caption_attribution_description: Čeština: Ukázkový ER diagram. English: A sample entity-relationship diagram set up by using an entity-relationship model technique proposed by Dr. Peter Pin-Shan Chen's 1976 paper The Entity Relationship Model: Toward a Unified View of Data. 한국어: ER 다이어그램 예제. Русский: Простая ER-модель MMORPG с использованием нотации Питера Чена. {description page is/was here.
context_page_description: Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model.
  Database management system manages the data accordingly.
  Database design involves classifying data and identifying interrelationships. This theoretical representation of the data is called an ontology. The ontology is the theory behind the database's design.
context_section_description: Database designs also include ER (entity-relationship model) diagrams. An ER diagram is a diagram that helps to design databases in an efficient way.
  Attributes in ER diagrams are usually modeled as an oval with the name of the attribute, linked to the entity or relationship that contains the attribute.
caption: A sample Entity-relationship diagram
exif: {}