ERD is Entiry Relationship diagram..
the main components are Entities, and their atributes with 
relations.

no we can 't do like that , the primary will be the foreign
key for the another table!!

The Primary Key of one table is foreign key for other 
table. The primary key of one table can be primary key of 
other tables, but there will be no use of that, it will 
break the RDBMS Rule and make the RDBMS slow.

No..We can't create the primary key of one table be a 
primary key in many other tables..
Primary Key will be the foreign key of another table..
only one primary key is possible 2 table.

create one blank database
then go to file there u will the option external date there
select import option then select from which data base u want
to retrieve all tables , if u select the tables the data
also comes along with that

Yes. You CAN. you need to set the referential integrity in 
Relations window in MS Access. When you add a relation to a 
table, you will be prompted through Edit relations window 
where you can set the cascade updates and cascade deletions.

After make ensure of having unique index for setting up 
the "Enforce referential integrity" at relationships in MS 
access we Can create a updatecascade, Deletecascade 
relation in Ms-Access.

Try and let to share.

Note:- Good Upendra.A