March 2

3 Types of BGR you can find in Databases


The relationships in data sources are like BGR (Boy Girl Relationship). There are 3 types:

1) One boyfriend to One girlfriend

This is the easiest to manage because one record from one table is linked to another record in a second table.

2) One boyfriend to Many girlfriends OR Many boyfriends to One girlfriend

One record from one table is related to many records in a second table

3) Many boyfriends to Many girlfriends

Many records from one table are related to many records in a second table. The relationship is highly complex and should be avoid at all cost. 


You may also like

Are you really a data-driven marketer?

Are you aware of these 2 developments?

Leave a Reply
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Subscribe to our newsletter now!