Hi,
I need to reproduce a table as per below and I would like some feedback on how to design such table?
Province of Employment | Participating employees | Male | Female
BC
AB
SK
MB
ON
QC
NB
NS
NL
PE
Federal
I'm thinking 2 tables:
The first one with 12 columns, one for each province + PK id.
The second table with 4 columns (male, female, PK id, and province_id which is related to the first table).
or my second thought will be:
Only 1 table with 23 columns (11 province x 2 genders, and PK id).
So basicaly, BC_male, BC_female, etc..
Any issue doing 2nd option?
Thanks
I need to reproduce a table as per below and I would like some feedback on how to design such table?
Province of Employment | Participating employees | Male | Female
BC
AB
SK
MB
ON
QC
NB
NS
NL
PE
Federal
I'm thinking 2 tables:
The first one with 12 columns, one for each province + PK id.
The second table with 4 columns (male, female, PK id, and province_id which is related to the first table).
or my second thought will be:
Only 1 table with 23 columns (11 province x 2 genders, and PK id).
So basicaly, BC_male, BC_female, etc..
Any issue doing 2nd option?
Thanks