Skip to main content

Designing One-to-One Tables

Learn Designing One-to-One Tables (Relationships & Database Design, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A one-to-one relationship means each row in table A matches at most one row in table B, and the reverse. In MySQL you build it by making the child's foreign key also UNIQUE (or by making the foreign key the child's primary key).

More lessons in Relationships & Database Design