SQL, One-to-Many Relationship

1-to-many relationship is obvious if you think about it. This can be achieved by putting the primary key of another table (1) to the current table (many) as the foreign key.

In other words, put the foreign key in the "many" side.