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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

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

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply