New answers tagged duplication
I think you should really look into using inheritance to manage this particular issue. Inheritance Table inheritance does many things in PostgreSQL, and I'd highly recommend you refer to the online documentation about inheritance to get a feel for what it does and how it might work for you. Since you stated that your comments are all structurally similar, ...
Properly normalized it will have 3 tables as follows: Kid kid_id (pk) classroom_id (fk to Classroom) Teacher teacher_id (pk) name Classroom classroom_id (pk) teacher_id (fk to teacher) This way you have no duplication and no update anomalies.
Top 50 recent answers are included