Made with
ConceptDraw
DIAGRAM 18

Developing Entity Relationship Diagrams

Entity Relationship diagrams are the powerful tool for clear and visual modeling the relationships between database entities. When developing Entity Relationship Diagrams are used a set of common block objects and lines to describe the structure of a database.

Use the ConceptDraw DIAGRAM software extended with Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park for designing ER diagrams, which offers the predesigned commonly used Entity relationship symbols and ER objects. Thanks to them you can make the ERDs easy understandable for all your colleagues.

Developing Entity Relationship Diagrams *

Sample 1. Entity Relationship Diagram (ERD), crow's foot notation


How to Build an Entity Relationship Diagram

When you need to visually represent the structure of relational database, Entity relationship diagram (ERD) is the best type of diagram for that case.

Most entity-relationship diagrams can be built with objects from Flowchart solution or ERD Solution which contains inbuilt templates. Follow these steps to create your own custom ERD diagram.

Don't be frightened if it looks complex, ConceptDraw DIAGRAM makes it easy to create an ERD, and hundreds of other diagrams, in minutes.

  • Start drawing with Entity object from Crow's foot ERD object.
    Note: This object contains several levels:
    1 - object itself
    2 - lines in the object
    3 - separate cell.
  • It is possible to set different setting to each level.
  • To switch from level to level, click on object with separate clicks when it's selected.

    Developing Entity Relationship Diagram

  • Add text.
  • Change object's color.

    Developing Entity Relationship Diagram

  • Copy Teachers table.
  • Add new rows via drop-down menu.
    Note: Adding and removing is always performed from a bottom row.
  • New added row will have same preferences as bottom one.

    Developing Entity Relationship Diagram

  • Paste copied table as many times as you need.

    Developing Entity Relationship Diagram

  • Filling the table.
    Note: To fill a separate cell, select it clicking with 3 separate clicks.
  • Delete excess rows via drop-down menu for each table.

    Developing Entity Relationship Diagram

  • Use M:1 (many-to-one) connector from ERD Crow’s Foot Notation library.
  • Connect needed rows of tables.

    Developing Entity Relationship Diagram

  • If you want to change connectors' type, select all connectors with held Shift button and click on Smart connector icon at ribbon.
  • To change connectors' elbow position, pull the yellow control dot.

    Developing Entity Relationship Diagram

  • Select tables from left and set the same distribution.

    Developing Entity Relationship Diagram

  • You may block the horizontal moving for object, so figure might be moved only vertically.

    Developing Entity Relationship Diagram

  • Use M:M (many-to-many) connector from ERD Crow’s Foot Notation library.
  • Set the needed connection.
    Note: When connector's end reaches connection point, it changes its appearance.

    Developing Entity Relationship Diagram

  • Edit connector's path manually with yellow control dots.

    Developing Entity Relationship Diagram

  • Select all with command+A.
  • Inspectors - Line - remove object lines (stroke).

    Developing Entity Relationship Diagram

  • Export your document to one of graphic formats.

    Developing Entity Relationship Diagram

  • Set the format and quality.

    Developing Entity Relationship Diagram

  • Your file is ready!

    Developing Entity Relationship Diagram

The Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park extends ConceptDraw DIAGRAM ector graphics and diagramming software with the ability to describe successfully a database using the Entity-Relationship model and easy create ERD.



Video. How to Build an Entity Relationship Diagram (2min 05sec)

Use ConceptDraw DIAGRAM enhanced with Entity Relationship Diagram (ERD) solution to draw you own ER diagrams using Chen's or Crow's Foot notations.







TEN RELATED HOW TO's:
Local area network connects computers and other network appliances within an area, such as office building or a campus. It can be difficult to provide such network without a predesigned plan. For these purposes you can use network diagram software, which helps you to create LAN network diagrams and office network diagrams quickly and effortless. This will speed up your work and you can save the diagram for the future network improvements. The following diagram illustrates a network topology of the small office. LAN configuration has a star topology. The local network joins 8 computers among which are several desktop PCs, laptop, two iMacs and iBook. The end-point devices are divided into three groups. Each group is connected to its hub. There is a network printer and a modem, which are interconnected with other devices through a network server. Each computer on the LAN can access the server through a corresponding hub.LAN Network Diagram
Picture: Network Diagram Software. LAN Network Diagrams. Physical Office Network Diagrams
Related Solution:
Services UML Diagram. ATM system. This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Use Case Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park. This sample shows the scheme of the servicing using the ATMs (Automated Teller Machines) and is used at the working of ATM banking systems, at the performing of the banking transactions.UML Use Case Diagram Example. <br>Services UML Diagram.  ATM system *
Picture: UML Use Case Diagram Example. Services UML Diagram. ATM system
Related Solution:
ConceptDraw DIAGRAM diagramming and vector drawing software extended with Mac OS User Interface Solution from the Software Development area is a powerful Mac OS GUI SoftwareMac OS GUI Software *
Picture: Mac OS GUI Software
Related Solution:
Chemical and Process Engineering solution contains variety predesigned process flow diagram elements relating to instrumentation, containers, piping and distribution necessary for chemical engineering, and can be used to map out chemical processes or easy creating various Chemical and Process Flow Diagrams in ConceptDraw DIAGRAM.Process Flow Diagram Symbols
Picture: Process Flow Diagram Symbols
Related Solution:
Interior design is an art of planning and coordinating the space in a building or on a floor to produce a charming and convenient environment for the client. You can ask professionals for help, or you can create floor plans easily with ConceptDraw DIAGRAM , using diverse libraries or altering numerous templates. You don’t need no formal training anymore to be a designer, isn’t it great? Using a ConceptDraw DIAGRAM floor plan software makes depicting of home or office layout ideas a simple task. It does not require special skills to make detailed and scaled floor plans. Adding furniture to design interior is also a breeze. You can draw and furnish your floor plans with a floor plan software. Moreover, using software for floor planning you gain an opportunity to share your plans and high-resolution images of your designs with clients or stakeholders.Create Floor Plans Easily with ConceptDraw DIAGRAM
Picture:
Create Floor Plans Easily
with ConceptDraw DIAGRAM Floor Design Software
Related Solution:
Agile methodology is an excellent alternative to waterfall and traditional sequential development. ConceptDraw DIAGRAM software extended with SCRUM Workflow solution is ideal for quick and easy designing various diagrams, charts, mind maps and schematics illustrating software development using Agile methodologies, and in particular Scrum methodology.Agile Methodology *
Picture: Agile Methodology
Related Solution:
UML Diagram Estate Agency. This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Use Case Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park. This sample shows the work of the estate agency and is used by the estate agencies, building companies, at the trainings of the estate agencies, for understanding the working processes of the estate agencies.UML Use Case Diagram Example - Estate Agency *
Picture: UML Use Case Diagram Example - Estate Agency
Related Solution:
ConceptDraw
DIAGRAM 18