Using the Erwin Software construct a logical data model using the IE notation to fit the following
Question:
Using the Erwin Software construct a logical data model using the IE notation to fit the following circumstances.
The Metro Hockey Association is made up of several leagues. A league has a unique name and a level. A hockey league will each contain at least four hockey teams. Each hockey team has a unique name and a location and is composed of six to twelve players, and one player captains the team.
Players have a team number within their team and a position. Players can only be registered on one team. Hockey teams play games against each other on specified dates. Teams may meet more than once a season. Each game has a score and a result. Teams have at least one coach and sometimes several coaches. Each coach has a unique id and a level of accreditation and a number of years of experience, and can coach multiple teams. A coach will have a role title for each team they coach. On any one team a coach may supervise other coaches. Coaches and players have names and addresses. Using the Erwin Software construct a logical data model using the IE notation to fit the following circumstances.
The Metro Hockey Association is made up of several leagues. A league has a unique name and a level. A hockey league will each contain at least four hockey teams. Each hockey team has a unique name and a location and is composed of six to twelve players, and one player captains the team.
Players have a team number within their team and a position. Players can only be registered on one team. Hockey teams play games against each other on specified dates. Teams may meet more than once a season. Each game has a score and a result. Teams have at least one coach and sometimes several coaches. Each coach has a unique id and a level of accreditation and a number of years of experience, and can coach multiple teams. A coach will have a role title for each team they coach. On any one team a coach may supervise other coaches. Coaches and players have names and addresses.