Tagged articles
Foreign Key
19 articles · Page 1 of 1
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

Although foreign keys enforce referential integrity, many enterprises avoid them because they can slow inserts, cause blocking cascade updates, trigger database update storms in high‑concurrency environments, and complicate sharding, leading developers to prefer redundant fields and handle relationships at the application layer.
Database PerformanceForeign KeyMySQL
0 likes · 6 min read

This article explains foreign key concepts in relational databases, showing how to create, modify, and drop foreign key constraints with SQL code, provides hands‑on exercises, discusses the pros and cons of using foreign keys, and outlines when they are appropriate or should be avoided.
DDLDMLForeign Key
0 likes · 6 min read

This article explains MySQL foreign keys, how to define them with CREATE TABLE syntax, cascade actions, limitations, pros and cons, and provides a complete MySQL 5.7 example with metadata queries and a cascade‑delete test, helping readers understand when to use or avoid foreign keys.
CascadeForeign KeyMySQL
0 likes · 7 min read

This article introduces SQL as the standard language for relational databases, explains how data is organized into tables with primary and foreign keys, and walks through essential keywords like SELECT, WHERE, and JOIN to query and relate data effectively.
Foreign KeyPrimary KeySQL
0 likes · 5 min read

The article explains that while MySQL foreign keys ensure data consistency and integrity, they introduce performance overhead, lock contention, and scalability issues—especially in high‑concurrency and sharded environments—leading many large internet firms to forego them in favor of application‑level solutions.
Database PerformanceForeign KeyMySQL
0 likes · 5 min read

This article outlines essential database design concepts, covering the relationship between source documents and entities, primary‑foreign key design, basic table characteristics, normalization standards, handling many‑to‑many relationships, primary key strategies, data redundancy, ER‑diagram considerations, view usage, and performance‑boosting techniques.
Database DesignForeign KeyPrimary Key
0 likes · 12 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 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


ITPUBJun 10, 2020 · Databases
This article explains what foreign keys are, how they enforce referential integrity in relational databases, the different actions (RESTRICT, CASCADE, SET NULL), their performance overhead demonstrated by benchmarks, and practical guidelines for simulating or using foreign keys in high‑concurrency applications.
CascadingDatabase DesignForeign Key
0 likes · 14 min read

This article examines the purpose, benefits, and drawbacks of MySQL foreign keys, presents various usage scenarios with performance tests, discusses constraints, and offers guidance on when to apply or avoid foreign keys in database design.
Database DesignForeign KeyMySQL
0 likes · 15 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

This article explains the three fundamental normal forms (1NF, 2NF, 3NF) and the five major database constraints, detailing how to apply primary and foreign keys, their syntax, and reference actions to design robust relational schemas.
3NFForeign KeyPrimary Key
0 likes · 6 min read

This article walks through choosing a web framework and database, introduces relational databases, explains design steps such as requirement analysis, table creation, primary key selection, relationship modeling (one‑to‑many, many‑to‑many, one‑to‑one) with SQL examples, and covers normalization forms, integrity rules, and indexing strategies.
Database DesignForeign KeyPrimary Key
0 likes · 19 min read

An overview of relational database normalization explains the three normal forms—1NF, 2NF, and 3NF—and details the five essential constraints (primary key, unique, default, foreign key, not null), including practical examples, rules, and foreign‑key syntax for proper schema design.
Foreign KeyNormal FormsPrimary Key
0 likes · 6 min read

This article explains core database concepts—including entities, attributes, relationships, the three normal forms, primary and foreign key rules, and the five main constraints—providing clear examples and visual diagrams to help developers design robust relational schemas.
Foreign KeyNormal FormsPrimary Key
0 likes · 6 min read

This article provides a step-by-step guide on creating and managing MySQL indexes (including INDEX and UNIQUE), defining primary keys with AUTO_INCREMENT, establishing foreign key relationships with cascade updates/deletes, and configuring the default storage engine, illustrated with practical SQL commands and examples.
Foreign KeyMySQLPrimary Key
0 likes · 11 min read


21CTOSep 27, 2015 · Databases
This article explains two key relational database design techniques: using auto‑increment or UUID physical primary keys for foreign key relationships, and employing optimistic locking with a version column to safely handle concurrent updates, while also covering when locks can be omitted.
Foreign KeyOptimistic LockPrimary Key
0 likes · 6 min read


21CTOSep 16, 2015 · Databases
This article explains why using a physical primary key for foreign‑key relationships, how to implement optimistic locking with a version column for concurrent updates, and when it’s safe to update records without any locking, providing practical SQL examples for reliable database design.
Database DesignForeign KeyOptimistic Lock
0 likes · 6 min read
