Dear all,

Thank you for your ideas guys, I am learning one step at a time to database stuffs.

For the meantime...I just used this table named [font="Courier New"]ADDRESS[/font], the columns are:

[font="Courier New"]person_id (int)

permanent (nvarchar(50))

mailing (nvarchar(50))

email (nvarchar(50))[/font]

I allowed [font="Courier New"]null[/font] for the three addresses. This [font="Courier New"]person_id[/font] is a foreign key to the [font="Courier New"]PERSON[/font] table's [font="Courier New"]person_id[/font]. Since the data entry in my VB .NET Form is of only three fields for the addresses, then maybe the simple program I am creating should not take into consideration (for the moment) if the student has many more than three emails and/or addresses, or if he/she has five contact numbers using five iPhones...:w00t:

I think what is wrong with our first data model (as attached to the opening of this thread) when we tried to "simulate" it in a piece of paper, it looks like a student can only have one entry for address and one entry for contact number, but to my VB .NET Form, the student-add-a-new-record-form have at least three (3) entries for addresses and at two (2) entries for contact numbers...

Well, back to the drawing board, I guess... :satisfied:

Your ideas and suggestions will be of great help in my succeeding database design in the future.

God bless you all.

Warm regards,

Mark Squall