Relational Database Design with MySQL: ER Modeling, Normalization, Storage Engine, Charset, Data Types, and Index Design

This article explains relational database design using MySQL, covering ER modeling, BCNF and 3NF normalization, storage engine and charset choices, data type selection, and index design, illustrated with examples and practical guidelines for building a student course selection system.

Data TypesDatabase designER Model

0 likes · 15 min read

Relational Database Design with MySQL: ER Modeling, Normalization, Storage Engine, Charset, Data Types, and Index Design

Architects Research Society

Dec 17, 2019 · Databases

Entity‑Relationship (ER) Model: Concepts, Types, and Modeling Issues

The article provides a comprehensive overview of the Entity‑Relationship (ER) model, covering its definition, conceptual, logical, and physical data models, notation variants, cardinality constraints, common pitfalls, semantic extensions, and limitations in relational database design.

ER Modelconceptual designdata modeling

0 likes · 17 min read

Entity‑Relationship (ER) Model: Concepts, Types, and Modeling Issues