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)?


Popular posts from this blog