What makes somthing many-to-one relationship?

[technoroj]

Thanks guys! Very nice explanation

Hi all,

Many to one relationship is nothing but many rows of one entity are joined with a single row of second entity.

for example
entity 1 contains
driver
conduction
tickets
passengers

entity 2 contains
Bus

now if you join both of this entities, the relationship will be (if 1->2) Many to one !


"Use of SQL Joins (Left join) is one solution of your database design"