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).