Relationships

Types of relationship

1:1

• 1 'customer' <--> 1 'customer_detail'
• One record in 'customer' table relates to only one record in 'customer_detail' table
• And vice-versa

1:Many

• 1 'book' -> n 'review'
• One record in 'book' table relates to many records in 'review' table
• Not vice-versa!

Many:Many

• n 'book' <--> n 'author'
• One record in 'book' table relates to many records in 'author' table
• And vice-versa
• Needs a intermediary table!