Question { Satyam, 5320 }

how to u retrieve all tables along with all the data

Answer

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

Question { 8713 }

can primary key of one table be a primary key in many other
tables

Answer

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