Section B Q4. Consider the following information about a baseball team database: A "Coach" has a coach ID, a name, and a major. A "Player" has a player ID, a name, a position, and an age. A "Training. Plan" has a training plan ID, a plan name, and a coach ID which refers to the coach who is in charge of the training plan. (a) Please draw entities "Coach", "Player", and "Training Plan" with the corresponding attributes and indicate their Primary Key(s) and Foreign Key(s), if any. (b) Each Training Plan is designed by one Coach, and one Coach can design multiple Training Plans. Each Player is trained by one Coach, while one Coach can train one or more Players. Onc Player can take part in one or more Training Plans and each Training Plan can involve multiple Players. Draw an ER diagram to show the relationships between the three entitics "Coach", "Training Plan" and "Player". (8 marks) (c) Refer to Q4.(b), design and draw an ER diagram to show the implementation of the relationship between the entities "Training Plan" and "Player