What can developer do with ERDPlus
ERDPlus is a web-based database modeling tool that lets you quickly and easily create Entity Relationship Diagrams (ERDs) Relational Schemas (Relational Diagrams) Star Schemas (Dimensional Models) More features Automatically convert ER Diagrams into Relational Schemas Export SQL Export diagrams as a PNG Save diagrams safely on our server
Export standard SQL Generate SQL from Relational Schemas and Star Schemas Select from common data types and data sizes Works with most contemporary RDBMS tools including Oracle, MySQL, Microsoft SQL Server, PostgresSQL, Teradata, IBM DB2, Microsoft Access, and others.
Entities Attributes Relationships The notation supports drawing regular and weak entities, various types of attributes (regular, unique, multi-valued, derived, composite, and optional), and all possible cardinality constraints of relationships (mandatory-many, optional-many, mandatory-one and optional-one).
Tables (Relations) Table Columns (including Primary and Foreign Keys) Referential Integrity Constraint Lines (pointing from a Foreign Key to the Primary Key it refers to) The tool supports quick creation of foreign keys and referential integrity lines by simple click-point-connect actions. This simplifies and quickens the process of creating relational schemas.
ERDPlus enables automatic conversion of ER Diagrams to Relational Schemas with one click of a button. This vastly speeds up the process of creating a Relational Schema based on an ER Diagram.
Fact Tables (Facts) Dimension Tables (Dimensions) The notation distinguishes fact tables from dimension tables by using a thicker frame around fact tables. This makes star schema diagrams easier to interpret. As with relational schemas, the tool supports quick creation of foreign keys and referential integrity lines by simple click-point-connect actions. This simplifies and quickens the process of creating star schemas.
How much does ERDPlus cost?
Free
Disclaimer: Last updated is 5 months ago. Always refer to https://erdplus.com for ERDPlus updates.
Top tools list:
Top Comparing Page: