What types of relationships exist between tables?

SQL keys and table design · Freshers

Model answer

One-to-one (user and profile), one-to-many (customer and orders, the most common), and many-to-many (students and courses), which needs a junction table holding both foreign keys.

Learn this topic

Keys and Table Design: Why Data Is Split Into Tables in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• What is a primary key?
• What is a foreign key?
• What is the difference between a primary key and a unique key?
• What are constraints in SQL?
• Natural key or surrogate key: which is better?
• How do you model a many-to-many relationship?