How To Insert Employee Record Along With Multiple Email Ids Into The Sql Database?

Hello Everyone,

I am bit confused.

I am using vwd2005 express,c# and sql express.

I have a webform that registers new employee(title,name,age,address,phone,email) and inserts those data into the sqldatabase.

The problem is there might exists 'N' number or email ids and phone nos for a single user.

for eg: user A might have 3 email address where has user B might have 5 email address.

so in that case its not appropriate to create 5 textboxes in the webform and create 5 column like email1,email2,email3,email4,email5 in the database for both users..

i hope your getting the point.

I tried to create a separate table for emails and phone.

But i am new to relational database.

So if i need to use Relational database then could anyone help me here to :-

1.create a table structure here.(what would be the structure of tbl_employee, tbl_email and tbl_phone)

2.How to write insert query if i am using RD here?

plz help explaining the concept with a simple running example.

Thanks in advance.

Jack.