Relation ships in SQl Server 2012

By default SQL server contains a relation ship between the two tables as "PARENT" and "CHILD",here the

PARENT table is called as independent table/dimension table which contains dimensions i.e the values in parent table will not change (mostly 99%)

CHILD table is called as dependent table/fact table which contains facts/measures i.e the values in child table contains facts/measures i.e it contains mostly (numeric values only in all the columns 95%) by using these we will perform the operations on these data.

parent and child relationship is with respect to type of data(based on dependable/not).

with respect to number of records present in two tables the relation ship is organized as below

one to one (1:1)
one parent record in parent table is related with one child record in child table.

One to Many(1:M)

one parent record in parent table is related with many child records in child table.

Many to One(M:1)

many parent records in parent table is related with one child record in child table.

Many to Many(m:m)

 it is a combination of (1:m and m:1) i.e if a two tables contains one to many and many to one relation ships the we can confirm that it is having many to many relation ship.

-->practically we can implement m:m relation ship with the help of "Bridge Table".

the following diagram explains all the relation ships

This diagram contains all the relation ships between project and emplist.

Thanks
GSV