A sports club runs a number of teams. Each team is made up of anumber of players of
the club and each player may play for more than one team. Eachteam has a number of
coaches, but the coach’s job is so time consuming that eachcoach can only coach one
team. For each team, team number, name, and address are stored.Each player’s ID
number, Name, DOB, and phone number are stored. A coach’s IDnumber, Name,
Address, phone number are also kept. Represent the aboveinformation on an entity
relation (ER) diagram, in 3rd normal form, underlining theprimary key for each entity.
A sports club runs a number of teams. Each team is made up of a number of players of the club and each player may play f
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am