This site uses cookies. By continuing to browse the ConceptDraw site you are agreeing to our Use of Site Cookies.

Entity Relationship Diagram - ERD - Software for Design Crows Foot ER Diagrams

ER-model is a data model which lets describe the conceptual schemes in a specific subject area. It can help to highlight the key entities and specify relationships that can be established between these entities. During the database design, it is realized the transformation of ER model into certain database scheme based on the chosen data model (relational, object, network, etc.). There are used two notations for ERDs: Crow's Foot and Chen's. Crow's Foot notation proposed by Gordon Everest represents the entity by rectangle containing its name (name must be unique within this model), and relation - by the line which links two entities involved in relationship. The relationship's plurality is graphically indicated by a "plug" on the end of the link, the optionality - by a circle. Entity-Relationship Diagrams based on Crow's Foot notation can be easily drawn using the ConceptDraw DIAGRAM. Extended with Entity-Relationship Diagram (ERD) solution, it is the best ERD diagrams software with powerful tools and ready design elements for Crow's Foot and Chen notations.
How to Build an Entity Relationship Diagram (ERD)
How to Build an Entity Relationship Diagram (ERD)

Components of ER Diagram

Entity-Relationship model gives the possibility to visually describe a database using the components of ER Diagram, entity relationship stencils, relationship symbols, work flow shapes. ER-diagram lets represent the data or entities, attributes of these entities and relationships between them, using standardized Crow’s Foot notation icons or Chen’s notation icons. An entity is an object of the real world, it can exist independently and has the instances which differ in attribute values (properties). The attributes give an unambiguous (uniquely) identification for the instance and are called the primary key, this key can be composite and combine several attributes. ConceptDraw DIAGRAM is a professional software available with Entity-Relationship Diagram (ERD) solution from Software Development area that lets create ERDs for various database systems, using Crow’s Foot and Chen’s notations. It is invaluable tool for software engineers and developers, it supports ODBC-compatible databases (Oracle, MySQL, MS Access, MS SQL, InterBase, Firebird and others).
The vector stencils library "Tools" contains 11 clipart images of hand tools and instruments for drawing illustrations.
"A tool is any physical item that can be used to achieve a goal, especially if the item is not consumed in the process. Informally the word is also used to describe a procedure or process with a specific purpose. Tool use by humans dates back millions of years, and other animals are also known to employ simple tools.
Tools that are used in particular fields or activities may have different designations such as "instrument", "utensil", "implement", "machine", or "apparatus". The set of tools needed to achieve a goal is "equipment". The knowledge of constructing, obtaining and using tools is technology." [Tool. Wikipedia]
The clip art example "Tools - Vector stencils library" was created in ConceptDraw PRO diagramming and vector drawing software using the Manufacturing and Maintenance solution from the Illustration area of ConceptDraw Solution Park.
Adjustable spanner
Adjustable spanner, spanner,
Lineman's pliers
Lineman's pliers, pliers,
Claw hammer
Claw hammer, hammer,
Phillips screwdriver
Phillips screwdriver, screwdriver,
Self-retracting tape measure
Self-retracting tape measure, tape-measure, tape measure,
Crosscut hand saw
Crosscut hand saw, saw,
Nail
Nail, nail,
Hori-Hori garden knife
Hori-Hori garden knife, knife,
Gardening trowel
Gardening trowel, spade,
Garden rake
Garden rake, rake,
Pistol-grip electric drill
Pistol-grip electric drill, drill,

manufacturing drawings Manufacturing and Maintenance

manufacturing drawings
Manufacturing and maintenance solution extends ConceptDraw DIAGRAM software with illustration samples, templates and vector stencils libraries with clip art of packaging systems, industrial vehicles, tools, resources and energy.
"A hand tool is any tool that is not a power tool – that is, one powered by hand (manual labour) rather than by an engine. Some examples of hand tools are hammers, spanners, pliers, screwdrivers and chisels. Hand tools are generally less dangerous than power tools." [Hand tool. Wikipedia]
"A power tool is a tool that is actuated by an additional power source and mechanism other than the solely manual labour used with hand tools. The most common types of power tools use electric motors. ...
Power tools are used in industry, in construction, in the garden, for housework tasks such as cooking, cleaning, and around the house for purposes of driving (fasteners), drilling, cutting, shaping, sanding, grinding, routing, polishing, painting, heating and more.
Power tools are classified as either stationary or portable, where portable means hand-held. Portable power tools have obvious advantages in mobility." [Power tool. Wikipedia]
The illustration example "7 tools that should be in every home" was created in the ConceptDraw PRO diagramming and vector drawing software using the Manufacturing and Maintenance solution from the Illustration area of ConceptDraw Solution Park.
Infographics
Infographics, tape-measure, tape measure, screwdriver, saw, pliers, nail, hammer, drill,
This vector stencils library contains 195 cloud computing icons.
Use it to design cloud computing infographic and diagrams with ConceptDraw PRO software.
"Cloud computing, also on-demand computing, is a kind of Internet-based computing that provides shared processing resources and data to computers and other devices on demand. It is a model for enabling ubiquitous, on-demand access to a shared pool of configurable computing resources (e.g., networks, servers, storage, applications and services), which can be rapidly provisioned and released with minimal management effort. Cloud computing and storage solutions provide users and enterprises with various capabilities to store and process their data in third-party data centers.
Cloud computing has become a highly demanded service or utility due to the advantages of high computing power, cheap cost of services, high performance, scalability, accessibility as well as availability." [Cloud computing. Wikipedia]
The vector stencils library "Cloud clipart" is included in the Cloud Computing Diagrams solution from the Computer and Networks area of ConceptDraw Solution Park.
Access point
Access point, access point,
Airport
Airport, airport,
Alert
Alert, Alert, bell,
Banknote
Banknote, banknote,
Banknote bundle
Banknote bundle, banknote bundle,
Banknote bundles
Banknote bundles, banknote bundles, banknote bundle,
Backup
Backup, backup,
Bar chart
Bar chart, bar chart icon,
Big data
Big data, big data,
Book (closed)
Book (closed), book,
Book (open)
Book (open), open book,
Books
Books, books,
Box, close
Box, close, box close,
Box, open
Box, open, box open,
Braces
Braces, braces,
Brackets
Brackets, brackets,
Bug
Bug, bug,
Building
Building, building,
Bus
Bus, bus,
Cable connection
Cable connection, cable connection,
Calculator
Calculator, calculator,
Calendar
Calendar, calendar,
Car
Car, car,
CD/DVD
CD/DVD, CD, DVD,
Check list
Check list, checklist, check list,
Check mark
Check mark, check mark,
Clock
Clock, clock,
Cloud
Cloud, cloud,
Cloud computing
Cloud computing, cloud computing, cloud,
Cloud database
Cloud database, cloud database, cloud,
Cloud hosting
Cloud hosting, cloud hosting, cloud,
Cloud storage
Cloud storage, cloud storage, cloud,
Code
Code, code,
Coffee cup
Coffee cup, coffee cup,
Coin
Coin, coin,
Coins stack
Coins stack, coins stack,
Coins stacks
Coins stacks, coins stacks,
Communication
Communication, communication,
Computer terminal
Computer terminal, computer terminal, ATM machine, info kiosk,
Console
Console, console,
CPU
CPU, CPU,
Credit card
Credit card, credit card,
Cubes
Cubes, cubes,
Dashboard
Dashboard, dashboard,
Database
Database, database,
Databases
Databases, databases,
Datacenter
Datacenter, datacenter,
Dialog box
Dialog box, dialog box,
Dialog boxes
Dialog boxes, dialog boxes,
Document
Document, document,
Documents
Documents, documents, document,
Dollar sign
Dollar sign, dollar sign,
Download
Download, download, cloud,
Earth
Earth, Earth, planet,
Email
Email, email,
Equal sign
Equal sign, equal sign,
Ethernet jack
Ethernet jack, ethernet jack,
Ethernet plug
Ethernet plug, ethernet plug,
Euro sign
Euro sign, euro sign,
Exclamation mark
Exclamation mark, exclamation mark,
Eye
Eye, eye,
Feed symbol
Feed symbol, feed symbol,
Feedback
Feedback, feedback,
File
File, file,
Files
Files, files,
Filter
Filter, filter, funnel,
Firewall
Firewall, firewall,
Flash drive
Flash drive, flash drive,
Folder
Folder, folder,
Folders
Folders, folders, folder,
Gamepad
Gamepad, gamepad,
Gauge
Gauge, gauge, speedometer,
Gear
Gear, gear,
Gears, 2
Gears, 2, gears,
Gears, 3
Gears, 3, gears,
Globe
Globe, globe,
Hacker
Hacker, hacker,
Hard drive
Hard drive, hard drive,
Heart
Heart, heart,
Heart rhythm
Heart rhythm, heart rhythm,
Home
Home, home,
Hosting
Hosting, hosting,
Hotel
Hotel, hotel,
House
House, house,
Image
Image, image, picture,
Info
Info, info,
IP phone
IP phone, IP phone,
Jet
Jet, Jet plane,
Key
Key, key,
Keyboard
Keyboard, keyboard,
Laptop
Laptop, laptop,
Lego
Lego, lego,
Letter
Letter, letter,
Light bulb
Light bulb, light bulb,
Lightning
Lightning, lightning,
Line chart
Line chart, line chart icon,
Linux penguin
Linux penguin, Linux penguin,
List
List, list,
Load balancer
Load balancer, load balancer,
Location mark
Location mark, location mark,
Lock, close
Lock, close, lock close,
Lock, open
Lock, open, lock open,
Lock and key
Lock and key, lock close, lock and key,
Log
Log, log,
Login
Login, login,
Logout
Logout, logout,
Magnifying glass
Magnifying glass, magnifying glass,
Mail
Mail, mail,
Map
Map, map,
Memory (RAM)
Memory (RAM), memory, RAM,
Microphone
Microphone, microphone,
Minus sign
Minus sign, minus sign,
Mobile phone
Mobile phone, mobile phone,
Monitor
Monitor, monitor,
Mouse
Mouse, mouse,
Movie
Movie, movie,
Music
Music, music,
Music player
Music player, music player,
Network
Network, network,
Network bus
Network bus, network bus,
Newspaper
Newspaper, newspaper,
NIC (Network interface controller)
NIC (Network interface controller), NIC, network interface controller,
Not found (Error 404)
Not found (Error 404), not found, error 404,
Notebook
Notebook, notebook,
Office printer
Office printer, office printer,
Operator
Operator, operator,
Page
Page, page,
Pages
Pages, pages,
PC
PC, pc, desktop computer,
Pencil
Pencil, pencil,
Photo
Photo, photo, picture,
Photo camera
Photo camera, photo camera,
Pie chart
Pie chart, pie chart icon,
Platform
Platform, platform,
Plus sign
Plus sign, plus sign,
Pound sign
Pound sign, pound sign,
Printer
Printer, printer,
Puzzle
Puzzle, puzzle,
Puzzles, 2x2
Puzzles, 2x2, puzzles,
Puzzles, 3x3
Puzzles, 3x3, puzzles,
Question sign
Question sign, question sign,
Rackmount server
Rackmount server, rackmount server,
Router
Router, router,
Safe
Safe, safe,
Satellite
Satellite, satellite,
Satellite antenna
Satellite antenna, satellite antenna,
Schedule
Schedule, schedule,
Sensor
Sensor, sensor,
Server
Server, server tower case,
Server rack
Server rack, server rack, rackmount server,
Shield
Shield, shield,
Ship
Ship, ship,
Shopping bag
Shopping bag, shopping bag,
Shopping basket
Shopping basket, shopping basket,
Shopping cart
Shopping cart, shopping cart,
Sign up
Sign up, sign up, pencil,
Smartphone
Smartphone, smartphone,
Social network
Social network, social network,
Software box
Software box, software box,
Sound
Sound, sound, dynamic,
Spider
Spider, spider,
Spreadsheet
Spreadsheet, spreadsheet,
SSD
SSD, SSD,
Star
Star, star,
Stars, 5
Stars, 5, stars, star,
Stethoscope
Stethoscope, stethoscope,
Stickman
Stickman, stickman,
Stickmen
Stickmen, stickmen, stickman,
Suitcase
Suitcase, suitcase,
Support
Support, support,
Switch
Switch, switch,
Syringe
Syringe, syringe,
Tablet computer
Tablet computer, tablet computer,
Tools
Tools, tools,
Train
Train, train,
Truck
Truck, truck,
Truck 2
Truck 2, truck,
TV
TV, tv,
Umbrella
Umbrella, umbrella,
Upload
Upload, upload, cloud,
User man
User man, user man,
User woman
User woman, user woman,
User profile
User profile, user profile, account, user man,
Video
Video, video,
Video camera
Video camera, video camera,
Video mail
Video mail, video mail, video,
Virtual disk
Virtual disk, virtual disk,
Virus
Virus, drawing shapes, computer virus,
Wallet
Wallet, wallet,
Web camera
Web camera, web camera,
Wifi antenna
Wifi antenna, wifi antenna,
Wireless
Wireless, wireless,
Wrench
Wrench, wrench,
X cross symbol
X cross symbol, X cross symbol,
Yen sign
Yen sign, yen sign,