In a relational data model, for normalization purposes, year lookup, quarter lookup, month lookup, and week lookups are not merged…