Relasi Database

Each row in the first table can be linked to multiple rows in the second table.

Each row in the first table can only be linked to one row in the second table, and vice versa.

Each row in the first table can be linked to no rows in the second table.

Each row in the first table must be linked to every row in the second table.

In one-to-many, both tables can have multiple links to each other.

In many-to-many, each row in the first table can only be linked to one row in the second table.

In one-to-many, a row in the first table can be linked to multiple rows in the second table, but not vice versa. In many-to-many, both tables can have multiple links to each other.

There is no difference between one-to-many and many-to-many relationships.

Data is more structured and organized.

It is harder to update data.

Data storage is more efficient by avoiding duplication.

It is easier to perform data analysis.

Complexity of database design

Ease of data retrieval

Unlimited storage capacity

Automatic data backup

One-to-One (1-1)

One-to-Many (1-M)

Many-to-Many (M-M)

One-to-Two (1-2)