Help in sql queries and insert command

Hello,
I am trying to create a database that will add persons details to the database.
I had created this database structure.

Thanks in advance for anybody who can help me to complete this database by creating insert commands and queries.
Zed

 

Unless the db server you are using requires id field, I would not use it. Instead, use another field that has a unique value for the primary key to speed up searches and joines.

IF NOT EXIST(select * from country where code = "USA")
BEGIN
   INSERT code
   values("United States of America","USA")
END

Code (markup):

 

I designed it in mysql. If you have other idea you can design it in your way.....

 

what you have looks ok to me, just delete the id columns and use one of the other fields for primary key if you can.