Tagged articles
ER diagram
27 articles · Page 1 of 1
This article reviews three free MySQL client tools—DBeaver, MySQL Workbench, and HeidiSQL—as alternatives to the paid Navicat, highlighting their supported databases, installation, language support, and unique features like built-in monitoring and ER diagrams in MySQL Workbench, which the author recommends for performance testing.
DBeaverER diagramHeidiSQL
0 likes · 6 min read

The article reviews SQLark, a Chinese one‑stop database development and management tool that supports Windows, macOS, and Linux, connects to major databases such as Oracle, MySQL and PostgreSQL, and integrates AI assistance, positioning it as a convenient, efficient alternative to Navicat and DBeaver.
AI assistantER diagramIntelligent SQL Editor
0 likes · 7 min read

The author compares common database clients, highlights the risks of cracked Navicat and limited DBeaver, then details how SQLark’s cross‑platform support, AI‑driven features, smart SQL editor, data migration, ER diagram generation, and test‑data generator provide a more efficient and secure workflow for developers.
AI assistantER diagramSQLark
0 likes · 7 min read

This guide explains why solid MySQL design matters, walks through the three normal forms with concrete SQL examples, covers primary keys, foreign keys, indexes, various table relationships, an online‑store case study, design recommendations, and performance‑tuning techniques.
Database DesignER diagramForeign Key
0 likes · 15 min read

This guide walks through five powerful Draw.io capabilities—including Alibaba Cloud and Azure icon libraries, sketch‑style diagrams with animation, automatic ER diagram generation from SQL, and Mermaid syntax import—showing how to enable and use each feature with screenshots.
Alibaba Cloud iconsAzure iconsDraw.io
0 likes · 6 min read

This article introduces an online SQL-to-ER diagram tool, explains its advantages, provides step‑by‑step usage instructions, showcases example SQL and Java code for parsing and generating ER diagrams, and discusses the underlying design‑pattern architecture such as Strategy, Factory, Dependency Injection, and Singleton.
ER diagramJavaSQL
0 likes · 17 min read

This article introduces core relational database concepts, covering tables, data models and ER diagrams, the fundamentals of SQL, and the first three normal forms, providing clear explanations and examples to build a solid foundation for further database study.
Data ModelingER diagramSQL
0 likes · 7 min read

This guide introduces DBeaver, a free Java‑based database management tool, covering its cross‑platform installation, JDBC connectivity to numerous relational and NoSQL databases, step‑by‑step connection setup, driver management, and how to generate ER diagrams from existing schemas.
DBeaverER diagramJDBC
0 likes · 6 min read

This guide walks you through downloading and installing the free, open‑source DBeaver tool, configuring connections to various databases such as PostgreSQL and Oracle via JDBC, testing those connections, and using the built‑in ER diagram feature to visualize database schemas.
DBeaverER diagramJDBC
0 likes · 6 min read

This guide introduces DBeaver, a free Java‑based database management tool, covering its cross‑platform installation, how to create connections for databases like PostgreSQL via JDBC, and how to generate ER diagrams from existing schemas, all illustrated with step‑by‑step screenshots.
DBeaverER diagramJDBC
0 likes · 7 min read

This article explains fundamental database design concepts, including candidate and primary keys, attributes, relations, ER diagram components, and detailed descriptions of the first, second, third, and BC normal forms with examples and how to resolve insertion, deletion, update, and redundancy anomalies.
Database DesignER diagramdata integrity
0 likes · 9 min read

Learn the fundamentals of logical database design, including key concepts such as candidate and primary keys, attributes, ER diagram symbols, and detailed explanations of the first, second, third, and BC normal forms with practical e‑commerce examples to avoid data anomalies.
1NF2NF3NF
0 likes · 8 min read

This article introduces DBeaver, a free open‑source database management tool, walks through downloading, installing, connecting to various databases, managing tables, using the SQL editor, customizing the UI, generating ER diagrams, and concludes with a summary of its strengths for developers and DBAs.
DBeaverER diagramSQL
0 likes · 7 min read

This guide introduces DBeaver, a free open‑source database management tool, covering its cross‑platform installation, how to create and configure database connections (including JDBC driver handling), and the steps to generate entity‑relationship diagrams from existing databases.
DBeaverER diagramJDBC
0 likes · 6 min read

This article explains the concepts of data model, data dictionary, database schema, and ER diagram, clarifies their differences, and compares them across stages, purposes, detail levels, authors, users, tools, and forms to help readers grasp database design terminology.
Data ModelingDatabase DesignER diagram
0 likes · 6 min read

This guide introduces DBeaver, a free open‑source database management tool, explains how to download and install it on various operating systems, shows how to create and test database connections (e.g., PostgreSQL), manage JDBC drivers, and generate ER diagrams from existing schemas.
DBeaverER diagramJDBC
0 likes · 6 min read

This guide explains how to download, install, and configure DBeaver, connect to various relational and NoSQL databases via JDBC, manage drivers manually when needed, and generate entity‑relationship diagrams directly from existing database schemas.
DBeaverER diagramJDBC
0 likes · 6 min read

This article introduces AntV X6, a versatile JavaScript graph‑editing engine, covering its core capabilities such as node and edge creation, custom HTML/React nodes, rich connection styles, grid and background options, interactive tools like ports, grouping, selection, undo/redo, and provides links to tutorials, demos, and extensibility mechanisms.
AntV X6DAGER diagram
0 likes · 11 min read

This article outlines essential database design principles, covering entity‑document relationships, primary and foreign keys, basic table characteristics, normalization versus denormalization, handling many‑to‑many relations, view usage, integrity constraints, and performance‑boosting techniques such as the “Three‑Less” rule and partitioning.
ER diagramForeign Keynormalization
0 likes · 13 min read

This guide walks you through installing the free, open‑source DBeaver client, configuring JDBC connections for databases such as PostgreSQL, and using its built‑in tools to create ER diagrams, covering essential steps, tips, and common pitfalls.
DBeaverER diagramJDBC
0 likes · 7 min read

This guide introduces DBeaver, a free open‑source Java‑based database management tool, covering its features, cross‑platform installation, how to create connections (e.g., PostgreSQL), test drivers, and generate ER diagrams, along with useful resource links.
DBeaverER diagramJDBC
0 likes · 7 min read

Learn how to install the open‑source DBeaver tool, configure connections for databases such as PostgreSQL and Oracle via JDBC, manage drivers, and generate entity‑relationship diagrams, with step‑by‑step screenshots and links to official site and GitHub repository.
DBeaverER diagramJDBC
0 likes · 7 min read

This guide walks you through downloading and installing DBeaver, setting up connections to various databases—including PostgreSQL, Oracle, and NoSQL platforms—using JDBC drivers, and creating ER diagrams, providing step‑by‑step instructions and screenshots to help you manage and visualize your data efficiently.
DBeaverER diagramJDBC
0 likes · 7 min read

This article introduces DBeaver, a free open‑source Java‑based database management tool, covering its cross‑platform installation, JDBC support for a wide range of relational and NoSQL databases, step‑by‑step connection setup, and how to generate ER diagrams from existing schemas.
DBeaverDatabase ConnectionER diagram
0 likes · 6 min read

This guide introduces DBeaver, a free open‑source Java‑based database management tool, explains how to download and install it on various operating systems, shows how to create connections to many relational and NoSQL databases via JDBC, and demonstrates generating ER diagrams from existing schemas.
DBeaverER diagramJDBC
0 likes · 6 min read

This article presents a comprehensive guide to database design, covering the relationship between source documents and entities, primary and foreign keys, table properties, normalization standards, handling many‑to‑many relationships, key selection, data redundancy, ER diagram considerations, view usage, intermediate and temporary tables, integrity constraints, the "Three‑Few" principle, and practical techniques for improving database performance.
Database DesignER diagramForeign Key
0 likes · 14 min read

This article explains the relationships between source documents and entities, the role of primary and foreign keys, the characteristics of base tables, normalization standards, handling many‑to‑many relationships, primary‑key generation methods, data redundancy concepts, ER‑diagram best practices, view usage, and performance‑optimizing techniques for relational databases.
Database DesignER diagramForeign Key
0 likes · 14 min read
