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

ConceptDraw PRO Database Modeling Software

ConceptDraw PRO Database Modeling Software

ConceptDraw PRO is a very easy-to-use and intuitive database design tool which can save you hundreds of work hours. See database diagram samples created with ConceptDraw PRO database modeling database diagram software. Read more
"An ER model is an abstract way of describing a database. In the case of a relational database, which stores data in tables, some of the data in these tables point to data in other tables - for instance, your entry in the database could point to several entries for each of the phone numbers that are yours. The ER model would say that you are an entity, and each phone number is an entity, and the relationship between you and the phone numbers is 'has a phone number'. Diagrams created to design these entities and relationships are called entity–relationship diagrams or ER diagrams.
Using the three schema approach to software engineering, there are three levels of ER models that may be developed. ...
Conceptual data model ... is the highest level ER model in that it contains the least granular detail but establishes the overall scope of what is to be included within the model set.
Logical ER model ... contains more detail than the conceptual ER model. In addition to master data entities, operational and transactional data entities are now defined.
The physical ER model is normally developed to be instantiated as a database. Therefore, each physical ER model must contain enough detail to produce a database and each physical ER model is technology dependent since each database management system is somewhat different.
Physical model ... is normally forward engineered to instantiate the structural metadata into a database management system as relational database objects such as database tables, database indexes such as unique key indexes, and database constraints such as a foreign key constraint or a commonality constraint." [Entity–relationship model. Wikipedia]
This crow's foot entity-relationship diagram (ERD) example "Educational data base" was created using the ConceptDraw PRO diagramming and vector drawing software extended with the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park. Read more
ERD
ERD, entity,

entity-relationship diagram, ER-diagram, database ERD Entity-Relationship Diagram (ERD)

entity-relationship diagram, ER-diagram, database ERD
An Entity-Relationship Diagram (ERD) is a visual presentation of entities and relationships. That type of diagrams is often used in the semi-structured or unstructured data in databases and information systems. At first glance ERD is similar to a flowch Read more
The vector stencils library "AWS Database" contains 30 Amazon Web Services database icons: Amazon DynamoDB symbols, Amazon Relational Database Service symbols, Amazon ElasticCache symbols, Amazon SimpleDB symbols, Amazon Redshift symbols.
Use it to draw AWS architecture diagrams of your cloud service.
The symbols example "AWS Database - Vector stencils library" was created using the ConceptDraw PRO diagramming and vector drawing software extended with the AWS Architecture Diagrams solution from the Computer and Networks area of ConceptDraw Solution Park. Read more
DynamoDB
DynamoDB, DynamoDB,
Table
Table, table,
Item
Item, item,
Items
Items, items,
Attribute
Attribute, attribute,
Attributes
Attributes, attributes,
Global secondary index
Global secondary index, global secondary index,
Amazon RDS
Amazon RDS, Amazon RDS,
RDS DB instance
RDS DB instance, RDS DB instance,
RDS DB instance standby (Multi-AZ)
RDS DB instance standby (Multi-AZ), RDS DB instance standby, Multi-AZ,
RDS DB instance read replica
RDS DB instance read replica, RDS DB instance read replica,
MySQL DB instance
MySQL DB instance, MySQL DB instance,
Oracle DB instance
Oracle DB instance, Oracle DB instance,
MS SQL instance
MS SQL
 instance, MS SQL instance,
PostgreSQL instance
PostgreSQL instance, PostgreSQL instance,
SQL master
SQL master, SQL master,
SQL slave
SQL slave, SQL slave,
PIOP
PIOP, PIOP,
ElastiCache
ElastiCache, ElastiCache,
Cache node
Cache node, cache node,
Redis
Redis, Redis,
Memcached
Memcached, Memcached,
Amazon SimpleDB
Amazon SimpleDB, Amazon SimpleDB,
Domain
Domain, domain,
Amazon Redshift
Amazon Redshift, Amazon Redshift,
Solid state disks
Solid state disks, solid state disks,
DW2 Dense Compute
DW2 Dense Compute, DW2 Dense Compute,
DW1 Dense Compute
DW1 Dense Compute, DW1 Dense Compute,