Tag

ER Modeling

0 views collected around this technical thread.

IT Xianyu

Apr 21, 2022 · Databases

Relational Database Design: ER Modeling, Normalization, Storage Engine, Character Set, Data Types, and Index Design

This article provides a comprehensive guide to relational database design with MySQL, covering ER modeling, BCNF and 3NF normalization, storage engine selection, character set and data type choices, and index design principles, illustrated through a student‑course selection example.

Database DesignER ModelingIndexing

0 likes · 10 min read

Relational Database Design: ER Modeling, Normalization, Storage Engine, Character Set, Data Types, and Index Design

Aikesheng Open Source Community

Dec 26, 2019 · Databases

Database Design: From ER Modeling to Normalization

This article explains the importance of good database design, walks through the stages of building an ER conceptual model, shows how to map entities, attributes, and relationships to relational schemas, and demonstrates how normalization (1NF, 2NF, 3NF, BCNF) improves schema quality using practical examples.

Database DesignER Modelingdata modeling

0 likes · 17 min read

Database Design: From ER Modeling to Normalization