Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want clear solution for all task International Cricket Match Scenario Overview: For the International Cricket league case study, you will have to follow the

I want clear solution for all task image text in transcribed
International Cricket Match Scenario Overview: For the International Cricket league case study, you will have to follow the steps in constructing the ER model as discussed in the class. The different ER components need to be identified in this case study. You may refer to the class activities and the other examples that are taught in the class. You should apply all the concepts taught in the class related to ER model in this case study. The deadline of submitting the assignment is 26 February 2020 (Wednesday). Case Study: I will be organizing the international cricket match (ICM) in next month in the cricket stadium. ICM has many teams and the match is played between two teams (called as Challengers TeamA and Knight Riders Team B) and has a date (such as 28 February 2020) and a score (such as 5 to 3). Each team has a name, city, a coach, captain and a group of players. Each player has a name, a position (such as right handed, left handed, fast bowler), a skill set and a set of records as in injury history. Each player should belong to only one team. There has to be a caption of the team, which is also a player of the team. Tasks: 1. Identify Entities (Strong and Weak entities) 2. Identify Attributes 3. Identify Relationship 4. Draw a complete ER diagram 5. Include mapping constraints

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

Database And Expert Systems Applications 31st International Conference Dexa 2020 Bratislava Slovakia September 14 17 2020 Proceedings Part 1 Lncs 12391

Authors: Sven Hartmann ,Josef Kung ,Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil

1st Edition

303059002X, 978-3030590024

More Books

Students also viewed these Databases questions