Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Structured Search For Big Data From Keywords To Key-objects

Authors: Mikhail Gilula

1st Edition

012804652X, 9780128046524

More Books

Students also viewed these Databases questions

Question

=+j Describe how EU directives impact IHRM.

Answered: 1 week ago

Question

=+and reduction in force, and intellectual property.

Answered: 1 week ago