I want to enforce a one to many relationship in our database.
We have a table of units
And we have a couple of tables that has a column named units.
My goal is to enforce that:
1- Every unit has an entry in the units table
2- When I change a spelling of a unit in the units table, all related tables with that units should get changed as well.
Now I would like to get the following:
A) A list of tables containing the unit column.
B) A list of tables containing data in their unit column that does not have matching entry in the units table.
C) Or perhaps hear from you experts, how do you suggest I proceed in order to accomplish that?