c# - creating an array for a primary key value -

i'm personal trainer , have programming background don't know database.. i'm trying create program can store clients personal information , if have health problems , medicines use in case happens can find information needed i'm using xampp, , c# ( open suggestions if more successful different language program)

what want create 3 tables;

1-personal_information (id(primary key) ,first_name,second_name,date of birth, 'and other information)

2-health_information ( disease, medicines)

3-size ( kg, , sizes of body parts chest, biceps, triceps etc.. , date )

but 1 client may have more 1 disease , may use more 1 medicine per disease) , want measure clients once in 2 months , add new sizes without losing previous values

so need array of health_information , size per id how do in mysql? i'm sure it's easy can't figure out

thanks in advance :)

in second table you'll want column called personal_information_id correspond row in personal_information table. when want retrieve data specific person execute query similar select * health_information personal_information_id = 12345. return rows in second table related patient 12345.

obviously you'll want similar size table.