Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started