In a relational data model, for normalization purposes, product category lookup, product sub-category lookup, product lookup, and and product feature…