Question: 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 I want clear solution for all task International Cricket Match Scenario Overview:

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

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!