Create table in SQL Server 2008R2

Question

Create two table and join them using join operation.

 

Including insert, update, delete, modify, select.

 

Both the table have atleast one same column specify primary key and foreign key.