Question

Q2. Based on the following requirements for a database for ABC international football League (ABC): The ABC has many teams, e
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SOLUTION-

I have drawn the ER diagram for the given problem football League(ABC).

ER- DIAGRAM-

Dale (ex-May 11th, 1999) Score (ex-4) gamc P Name host_team guest team Team_Name Team belongs to Player Country P_Position Co

In this diagram i have given Entity , attribute, realtionship in he dairam.

Entity/strong Entity- Team , Player

Attribute- Team_Name, Country, Coach, Captain, Score ,Date, P_Name, Skill Level, P_Position

Relationship-  belongs to, game

IF YOU HAVE ANY DOUBT PLEASE COMMENT DOWN BELOW I WILL SOLVE IT FOR YOU:)

----------------PLEAESE RATE THE ANSWER-----------THANK YOU!!!!!!!!----------

Add a comment
Know the answer?
Add Answer to:
Q2. Based on the following requirements for a database for ABC international football League (ABC): The...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • policy number, owner name, insured amount, and name of the verencialy. (25 pts.) Design an ER...

    policy number, owner name, insured amount, and name of the verencialy. (25 pts.) Design an ER diagram for a simple database for the National Hockey League (NHL): • The NHL has many teams Each team has a name, a city, a coach, a captain, and a set of players Each player belongs to only one team Each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records (each has...

  • We would like to design a database to maintain information about hospital staff, including doctors and...

    We would like to design a database to maintain information about hospital staff, including doctors and nurses, and patients at the hospital. Construct a crow’s feet diagram using the information provided. The information we need includes: Staff, including their names, addresses and social-security numbers. Patients, including their names, addresses, and the name of their insurance company. Patients are each assigned to a ward (room). Those staff who are nurses are assigned to zero or more wards. Each ward has at...

  • Due to your experience in designing the database for the "Legendary League" game, you have been...

    Due to your experience in designing the database for the "Legendary League" game, you have been asked to design the ER diagram for a bigger database to manage the events for the "Legendary League" eSports Oceanic Championship (OC). The requirements are as follows: Registered teams compete in the OC. Each team has a name, and a number of team members. A team also maintains a rank throughout the OC, reflecting how well it is doing in the championship. Team members...

  • Please answer CLEARLY and LEGIBLE Relational Algebra The local city youth league needs a database system...

    Please answer CLEARLY and LEGIBLE Relational Algebra The local city youth league needs a database system to help track children who sign up to play soccer. Data needs to be kept on each team, the children who will play on each team, and their parents. Also, data needs to be kept on the coaches for each team. Each team is given an ID and Team name. Each player and each parent are given an ID when they sign up. Each...

  • Recall the ERD exercise problem: Leagues: Leagues have a name. League names are unique. Teams: Teams...

    Recall the ERD exercise problem: Leagues: Leagues have a name. League names are unique. Teams: Teams have names, players, a captain (who is also a player) and uniform colors. No league has two teams with the same name. But there can be teams with the same name in different leagues. Each team has uniforms of one or more colors. There are two types of teams, sponsored and not sponsored. A sponsored team has a sponsoring company with the company contact...

  • Database model help

    (From the book Database Systems 10th editions by Coronel pg.142-143)The local city youth league needs a database system to help track children who sign up to play soccer. Data need to be kept on each team and the children who will beplaying on each team and their parents. Also, data need to be kept on the coaches for each team. Draw the data model described below:Entities required: Team, Player, Coach, and ParentAttributes required:- Team:Team ID number, Team name, and Team...

  • Create an ER diagram to model the following specification: A football team has multiple players Each...

    Create an ER diagram to model the following specification: A football team has multiple players Each team has a name and a home city. No two teams can have the same name and home city combination. Every player must be on a team. Each player has a name and a player number; the combination of the player number and the team information is unique

  • Create an ER diagram to model the following specification: A football team has multiple players Each...

    Create an ER diagram to model the following specification: A football team has multiple players Each team has a name and a home city. No two teams can have the same name and home city combination. Every player must be on a team. Each player has a name and a player number; the combination of the player number and the team information is unique

  • Given the following business scenario, create a Crow’s Foot ERD The local city youth league needs...

    Given the following business scenario, create a Crow’s Foot ERD The local city youth league needs a database system to help track children that sign up to play soccer. Data needs to be kept on each team and the children that will be playing on each team and their parents. The team has an ID, name, and colors. Data stored for each player consists of the id, first name, last name, and age. Also, data needs to be kept on...

  • Crow's Foor Notation

    Create a Crow’s Foot Notation Entity Relationship Diagram (ERD) to support the following business operations:The local city youth league needs a database system to help track children who sign up to play soccer. Data needs to be kept on each team, the children who will play on each team, and their parents. Also, data needs to be kept on the coaches for each team and matches.You need to store theTeam IDTeam namePlayer IDPlayer first name,Player last name, andPlayer age of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT