35+ Design Er Diagram 1 To 1 Relationship Example Download Zip Pictures. An er diagram shows the relationship among entity sets. Er diagrams are used to model and design relational databases, in terms of logic and business er diagrams are composed of entities, relationships and attributes.
Open in desktop download zip.
Data modelers create er diagrams in order to fully understand and describe data before it is developed into a physical database. For example, a doctor prescribes a drug for a patient. In other words, er diagrams help to explain the logical structure of databases. The main value of carefully constructing an erd is that it can readily be converted into a database structure.