Skip to main content

One-to-One Relationship

Learn One-to-One Relationship (Database Fundamentals, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction In a one-to-one relationship each row in table A matches at most one row in table B and vice versa, e.g. a user and the single profile row for that user. Implement it with a FK that is also UNIQUE (or the child's PK).

More lessons in Database Fundamentals