There are three tables in the database:
1) student (there is a family column where one of the two values ​​is written from another table)
2) family (this is the table where there are two values, "full" or "incomplete")
3) family status (here family status, for example, “without father”, “without mother”, “parents are divorced”, etc.)
I need that in 1 table in the column the family should be of the type “Complete parents divorced” or “Incomplete without mother and without father” or “Incomplete without father”, something like

  • one
    Curved data scheme generates insane desires. Better redo if it's not too late. - Akina

1 answer 1

I think you need one table with values

students(family{полная;неполная},status{without_father;withour_mother;parents_divorced})

If you need two or more, then you need to make the table links across

  • OO ATP) damn long puzzled :), ATP again! - As Lan