Question: Question 1 Carefully read the case study below. The KL Netball Club needs a database system to help track members that sign up to play


Question 1 Carefully read the case study below. The KL Netball Club needs a database system to help track members that sign up to play netball. Data needs to be kept on each team, the teenagers playing, and their guardians. Also, data needs to be kept on the coaches for each team. The followings are the classes and attributes for each class: The following associations must be defined: - The Team is related to the Player. - The Team is related to Coach. - A Player is related to Guardian. The constraints are defined as follows: - A Team may or may not have a Player. - APlayer must have a Team. - A Team may have many Players. - A Player has only one team. - A Team may or may not have a Coach. - A Coach must have a Team. - A Team may have many Coaches. - A Coach has one or many team. a) From the mentioned data model, sketch the Class Diagram. Be certain with the Primary Key (PK) and Foreign Key (FK) for each class. Show the associations and multiplicities. You do not need to include the methods (behaviors) for each class) in your class diagram
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
