Combine values ​​to define a primary key?

advertisements

I have a series of rows with the following information that I want to store in a relational database. I'm thinking about combining the min/max age with the gender to define a primary key but I'm really not sure about it. What do you think would be the best way to solve this?.

Min age = 9
Max age = 13
Gender = 'M'
Nutrient A = 500
Nutrient B = 500
...
Nutrient Z = 600

Min age = 9
Max age = 13
Gender = 'F'
Nutrient A = 500
Nutrient B = 500
...
Nutrient Z = 600


You can just use both fields as your primary key--

Age Int NOT NULL,
Gender char NOT NULL,
CONSTRAINT id PRIMARY KEY (Age, Gender)