normalization - mySql normal form and saving fields -
i need insert database composite informations:
name, section, room
i want clarify that:
1) these informations unique field , i'll use them togheter;
2) name present section , room sometimes;
3)splitting force me use 3 field instead of 1 i'll set null section and/or room if not present;
4)not splitting force me set field length high contain values
so question is: better split data 3 fields , "concat " them time need them or store them unique field?
is better save fields number or fields length (and preserve normal form)?