Detect columns that behave like foreign keys but have no constraint, review confidence grading, verify against real data, and declare them with ALTER TABLE.