HomeworkLib
Question

Q2. Based on the following requirements for a database for ABC international football League (ABC): The ABC has many teams, e
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

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!!!!!!!!----------

0 0
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.

Log In

Sign Up

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...

  • Read this and solve the question number 10 below. The NCAA (National Collegiate Athletic Association) wants...

    Read this and solve the question number 10 below. The NCAA (National Collegiate Athletic Association) wants to develop a database to keep track of information about college basketball. Each university team belongs to only one conference (e.g., the University of Houston belongs to Conference USA; the University of Cincinnati belongs to the Big East Conference, etc.). A conference has several teams; no conference has less than five (5) teams. Each team can have a maximum of twenty players and a...

  • 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...

  • Consider the following relational database schema, which describes the schedule of competition among National Football (soccer)...

    Consider the following relational database schema, which describes the schedule of competition among National Football (soccer) Teams in the upcoming 2018 FIFA World Cup. STADIUMS (StadiumName, City, Capacity) MATCHES (StadiumName, Date, Time, Country-1, Country-2) TEAMS (Country, Trainer, Continent) PLAYERS (PlayerName, Country, NumGoals, Position) Express the following query in SQL: List the player names of all the Goalkeepers (Position), along with their corresponding country name and trainer/coach.

  • 21. The local city youth league needs a database system to help track children who sign...

    21. 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. Draw a data model with the entities and attributes described here. Entities required: Team, Player, Coach, and Parent Attributes required: Team: Team ID number, Team name, and Team colors...

  • 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

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