Relationship normalization in SQL Server I want to know should I remove PersonTypeId from Persons table or is it a good idea to have it in there?
You need it there so that you know what PersonType is Person is. Without it, you don’t know.

Normalisation means that you don’t have PersonTypeName in the Persons table. But PersonTypeID is fine and what you need.