Upon discussion with business analysts, data modeler can come up with the following conclusions regarding grouping and relationship between the…