CODE EXAMPLE FOR SQL

one to one and one to many relationship

One-to-one relationships associate one record in one table
with a single record in the other table.
One-to-many relationships associate one record in one table with 
many records in the other table