BestHub
Sign in
Tag

ER diagram

0 views collected around this technical thread.

Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Dec 7, 2024 · Backend Development

Online SQL-to-ER Diagram Tool: Features, Usage, and Implementation Details

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
Online SQL-to-ER Diagram Tool: Features, Usage, and Implementation Details
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 11, 2024 · Databases

Fundamentals of Relational Databases: Tables, Data Modeling, SQL, and Normalization

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 diagramRelational Database
0 likes · 7 min read
Fundamentals of Relational Databases: Tables, Data Modeling, SQL, and Normalization
IT Architects Alliance
IT Architects Alliance
Jan 13, 2023 · Databases

Database Design Fundamentals: Key Concepts, ER Diagrams, and Normal Forms

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.

Data IntegrityDatabase DesignER diagram
0 likes · 9 min read
Database Design Fundamentals: Key Concepts, ER Diagrams, and Normal Forms
Selected Java Interview Questions
Selected Java Interview Questions
Aug 29, 2021 · Databases

Getting Started with DBeaver: Installation, Connecting to Databases, and Generating ER Diagrams

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.

DBeaverDatabase ManagementER diagram
0 likes · 6 min read
Getting Started with DBeaver: Installation, Connecting to Databases, and Generating ER Diagrams
Java Architect Essentials
Java Architect Essentials
Apr 4, 2021 · Databases

Getting Started with DBeaver: Installation, Database Connections, and ER Diagram Generation

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.

DBeaverDatabase ManagementER diagram
0 likes · 6 min read
Getting Started with DBeaver: Installation, Database Connections, and ER Diagram Generation
Architecture Digest
Architecture Digest
Nov 12, 2020 · Databases

Key Principles of Database Design: From Entity Relationships to Performance Optimization

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.

Database DesignER diagramforeign key
0 likes · 13 min read
Key Principles of Database Design: From Entity Relationships to Performance Optimization
Architect's Tech Stack
Architect's Tech Stack
Sep 19, 2020 · Databases

Getting Started with DBeaver: Installation, Database Connections, and ER Diagram Generation

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 ManagementER diagram
0 likes · 6 min read
Getting Started with DBeaver: Installation, Database Connections, and ER Diagram Generation
Java Captain
Java Captain
Sep 19, 2020 · Databases

Getting Started with DBeaver: Installation, Database Connections, and ER Diagram Creation

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.

DBeaverDatabase ManagementER diagram
0 likes · 6 min read
Getting Started with DBeaver: Installation, Database Connections, and ER Diagram Creation
Selected Java Interview Questions
Selected Java Interview Questions
Aug 4, 2020 · Databases

Fundamental Concepts and Best Practices for Database Design

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
Fundamental Concepts and Best Practices for Database Design
Java Captain
Java Captain
Nov 1, 2019 · Databases

Key Principles of Database Design: Primary/Foreign Keys, Normalization, and Table Types

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.

Data RedundancyDatabase DesignER diagram
0 likes · 14 min read
Key Principles of Database Design: Primary/Foreign Keys, Normalization, and Table Types