Entity Relationship Diagram

entity-relationship diagram (model)

By Vangie Beal An entity relationship model, also called an entity-relationship (ER) diagram, is a graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems. An entity is a piece of data-an object or concept about which data is stored.

  Relationships Between Entities

A relationship is how the data is shared between entities. There are three types of relationships between entities:

  1. One-to-One

One instance of an entity (A) is associated with one other instance of another entity (B). For example, in a database of employees, each employee name (A) is associated with only one social security 
number (B).

2. One-to-Many

One instance of an entity (A) is associated with zero, one or many instances of another entity (B), but for one instance of entity B there is only one instance of entity A. For example, for a company with all employees working in one building, the building name (A) is associated with many different employees (B), but those employees all share the same singular association with entity A.

  3. Many-to-Many

One instance of an entity (A) is associated with one, zero or many instances of another entity (B), and one instance of entity B is associated with one, zero or many instances of entity A. For example, for a company in which all of its employees work on multiple projects, each instance of an employee (A) is associated with many instances of a project (B), and at the same time, each instance of a project (B) has multiple employees (A) associated with it.

 

ER Diagram Symbols

In an ER diagram, symbols are commonly used to to represent the types of information. Most diagrams will use the following:

  • Boxes represent entities.
  • Diamonds represent relationships
  • Circles (ovals) represent attributes.

Comments

Post a Comment

Popular posts from this blog

What is Data Flow Diagram (DFD)

Image
Data Flow Diagram Symbols. DFD Library Data Flow Diagram Symbols. DFD Library Data Flow Diagrams graphically represent the information transfers and process steps of a system. They visually depict how data are processed by a system in terms of inputs and outputs, how occurs the input in a system, how the data flow through an information system and where they are stored, and how occurs output from the system. DFDs give the overview of the system and models the processes aspects, they are maintained with other methods of structured systems analysis. The main goal of DFDs is achievement of understanding between developers and users. For their construction are used two notations - Gane-Sarson and Yourdon, each of them uses its own set of symbols. Data Flow Diagrams solution from Software Development area extends the ConceptDraw PRO software with templates, samples, and predesigned libraries of data flow diagram symbols for both notations, allowing you
Read more
Image
New Technologies  VR, AR, MR  Virtual Reality Virtual reality is the use of computer technology to create simulated environments. Virtual reality places the user inside a three-dimensional experience. Instead of viewing a screen in front of them, users are immersed in and interact with 3D worlds. Simulation of human senses—all five of them—transforms a computer into a vehicle into new worlds. The only limitation to a superb VR experience is computing power and content availability. Three Categories Of VR Non-Immersive Virtual Reality : This category is often overlooked as VR simply because it’s so common. Non-immersive VR technology features a computer-generated virtual environment where the user simultaneously remains aware and controlled by their physical environment. Video games are a prime example of non-immersive VR. Semi-Immersive Virtual Reality :   This type of VR provides an experience partially based in a virtual environment. This type of VR makes sense for educational and tr
Read more