For eg: if there are multiple emails from same domain name, then domain name column will have same entry multiple times.
When domain is moved to sub table, main table still has duplicate entries, in form of foreign keys, while domain table has unique entry for each domain name
For eg: if there are multiple emails from same domain name, then domain name column will have same entry multiple times.
When domain is moved to sub table, main table still has duplicate entries, in form of foreign keys, while domain table has unique entry for each domain name