Any software for designing ER diagrams or relationship for database [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. 开发者_C百科 Closed 10 years ago.

I want make the ER diagram or database schema . Is there any software which can help me in drawing those relations and links with some samples for most used tasks on we

---

MySQL Workbench can help you with that. http://wb.mysql.com/ There is an ERD tool that can read your existing db and create a diagram you can then modify. It will also synchronize changes to your database if that is your desire as well.

---

Try Edraw...It is paid but you can use evaluation version. You can get information from http://www.edrawsoft.com/

All most all diagrams are available to draw in this software.

---

I use Dia for my ER diagrams. Dia can also be used for other drawing of similar style, including flowcharts etc.

---

Enterprise Architect is probably more expensive than you are looking for but it has everything.

---

Offer Entity Relation (ER) model for information storage formations (teams), players and football teams matches

The minimum required entities and relations should be:

• teams (teams)
• Players
• Matches
• The position of players
• Races

Relationship between the entities is as follows:

• A player may play in more matches
• In match play more players

The team has 11 players minimum. In match play 2 teams. A team has many players and a player can only play for a team in a particular match. A player may play in zero or more matches. The design should allow the maintenance of records for the position which each player has played in his team in a specific game and has scored many goals in the match.

Information should be recorded and who was host of the match, the match date and time and which should be recorded in the match race was developed (eg Champions League, Premiership, FA Cup, etc.).