Put unique constraint on all your lookup table 'name' field

[LunaAsefaw]

Since this is a lookup table, the values stored here will become values in a dropdown list so we don't want duplicate names so please implement a unique constraint on such fields. This applies to all your lookup tables

[charlesmudima]

Completed.