Football team management model

Question

Hello,

I need to model a database of my choice and manage it in Access, as part of a university project.

I have chosen to model football team management.

I would like to know if some of you would be kind enough to take a look at my MCD.

Thank you in advance and have a nice day ;)

Magalie.

JvDo · Accepted Answer

Good evening Magalie,

I’ve spent a bit of time on your ER diagram (MCD), and even though I don’t know much about football or MCDs, I’d like to offer a few remarks.

1) Your membership and training relationships resemble an employment relationship between club and player and coach.

2) I imagine a club owns several teams of different age groups and levels. There can be several coaches. I would propose a new object called team and a relationship entrainer between coach and team, and a membership relationship between team and club.

3) For matches, I would model them as an object linked to team, referee, and two new objects: competition and stadium.
- a match would belong to a competition (league, cup, friendly) of a certain level (departmental, regional, national...) with a referee authorization level.
- a match would take place in a stadium.
- a match would be officiated by 4 licensed referees.
- a match would see two teams meet (potentially from the same club).
- a team would be engaged in competitions.
- a team would be composed of players (field players or substitutes).

4) I would also model a relationship arbitrate between referee and match.

5) I would create a relationship manage (dirige) between a new object manager (dirigeant) and club.

I’m getting a bit tangled in my italics for objects and relationships. I hope it’s readable.

For the cardinalities, I’ll leave that to you (:-)

Kind regards,
JvDo

Magalie · Answer

I’m bringing up this topic because I would really need someone to take a look at my project and give me their opinion: s   Thanks in advance ;)   Magalie.

Galsungen · Answer

put your MCD in image format (jpg or pdf) and upload it, then give the link here, it might be easier if you want others to look at it^^ -- And a time for every matter under the heaven ...

Magalie · Answer

Once said, done.

[URL=http://img424.imageshack.us/my.php?image=mcdfoot4yk.jpg][IMG]http://img424.imageshack.us/img424/6093/mcdfoot4yk.th.jpg[/IMG][/URL]

I start from the principle that a coach has passed through several clubs, just like a player.

Magalie · Answer

Sorry about the link, I messed up a bit :s

Magalie · Answer

JvDo, thank you for the time you devoted to reading my MCD and for the comments you made.

I have simplified the model and the database of my project based on the assumption that I only manage professional football teams at the highest level (the type of Ligue 1 in France and equivalent level in Europe).

I think your comments fit the case where you have several teams of different levels within the same club with the creation of the table team.

Tell me if you agree.

md · Answer

Hello  Sports manager I would potentially like to review your work  Please send it to me by email Best regards

Cadoudal56 · Answer

Hello,

If anyone is interested, I’ve achieved a fairly similar modeling in PHP + MySQL so that we can turn it into a website. You will find the specifications here as well as the entire system for download: http://phpcompet.free.fr

--------------------------------------------------------------------------------------------

PHP Competition System is multilingual, multi-design and fully customizable. It allows you to manage clubs, players, stadiums, referees, championships and cups, the records and information of your favorite sport

---------------------------------------------------------------------------------------------

If you need a hand, there is a support forum and if needed I am reachable by email...

Have a good day
@+
cadoudal56

zeba3 · Answer

Hi Magalie... I would like to have a copy of your modeling. I am not only a big football fan but I am currently working on a university project on marketing modeling....
So if you could send a copy to my email.... shahista3@gmail.com

I would be grateful.

Thank you

Zeba

laideur · Answer

I have a problem: it concerns managing a sports competition using the TDA file

Piwi7012 · Answer

Hi Magalie, I’m a football fan. You’ll be sending your work to me—thanks a lot from me. world_piwi@hot....

Angys · Answer

Hi Magalie, this is Angys, a Computer Science engineering student, and I’d love to see your MCD. I should mention that I’ve had a similar project recently: computerizing the Africa Cup of Nations, abbreviated CAN. This project can be a bit more challenging than it seems, and for me I’m programming with SQL Server. Thank you.

Angys · Answer

Here is the translation:

"Here is Magalie my email goasp20032002@yahoo.fr"

tib23 · Answer

yes, I agree to see your ERD (Entity-Relationship Diagram)

audric13 · Answer

Hello everyone, I would like to know if you know how to build a football (soccer) team from scratch, knowing that I know nothing at all. I would like to know from A to Z the actions to take, the documents to have, etc. Thanks in advance for giving me a hand. My email address is: audric13@hotmail.fr

aboude · Answer

hello how are you enchant me this diallo aboubacar i am looking for a football training to train myself i am 15 years old i live in cote d ivoire here is my email roibouba@hotmail.fr here is my phone 00225 46587167 please help me

mehdi wac · Answer

http://modareb.maktoob.com/ is a site for training teams

Football team management model

17 answers

Update w10 kb5122878 impossible

Customize and sanctuarize your windows folder icons

Trio gigaset a605h no longer works

Slow startup on asus vivobook after battery drained

Very slow computer

Outlook problem

exorbitant cost of a landline in france without internet in 2026

Retrieving conversation histories: mediapart-bardella case

Black screen with my thumbnails on the pc screen

Gmail password problem