I have a "user" table, with many attributes including "nationality". the user can have multiple nationalities, so it sounds as if I have to design a new table to store this multiple value.
but what if I stored the first nationality in "user" table, and each of the remaining nationalities belonging to the same user would go to the nationality table.
I am thinking about this solution since it's pretty rare to have a user with multiple nationalities.. so, I can keep my design clean this way.
Is this feasible? is it a bad design?