In a relational data model, for normalization purposes, corporate office lookup, region lookup, branch lookup, and employee lookups are not…