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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!