Hello there,

Me and two other guys are doing a high school project that we have time for till december. We want to make a database of soccer penalties. We want to be make this database useful to players, coaches and goalies alike. At the moment we want these points incorporated:

Name Player
Left/Right leg
Position
Name goalkeeper

Is it a penalty shootout
Number in shootout
How much time does the goalkeeper take to get to his line?
How much time does the player take?
Is the keeper moving before the shot?
Does the goalkeeper choose an angle?
Which angle?
Does the ball go in?
How many paces?
Does the player fake?
Where in goal? (9 areas)
What competition
What date?
Club 1
Club 2

We want to make the program as usable as possibile in real life. So one idea was to make it accesible by the web. So other people can update their own penalties into the database. We also want to make it usable while not being connected to the web. (Sitting next to a soccer field.)

So the question is..
What is the best database system to use for this?
I was personally thinking about either MySQL or MS Acess
I have experience with simple access databases.

For MySQL you will need to have a local (test) server installed to test database queries. I believe Access will require the same. However, either one will definitely do what you want it to do.

Database Concepts and Design forum get more readers and more responses there from people that can actually help you make your decision.

Before I offer a suggestion, I'd like to say that you did a great job on composing a first post. You described your problem in enough detail for someone to be able to help you, and you asked for help instead of an outright solution. DBForums sees far too many students asking us to do their homework for them, so it is really nice to see that there still are some good students!

Having done a very similar project for an AYSO region a few years ago, I can tell you that in an entire season, not a single "rich client" designed to run on a laptop ever returned data to the repository. This may have been biased because I wrote the beastie and used my cell phone to enter data, or because nearly every coach had a cell phone and only a few folks ever brought a laptop to a soccer pitch. The short answer is that the only data I ever got was from either HTTP or WAP, no data ever came from the application.
_______________________________________________
jewellery case
girdle shapewear

I think that you'll get more readers and more responses there from people that can actually help you make your decision.

Before I offer a suggestion, I'd like to say that you did a great job on composing a first post. You described your problem in enough detail for someone to be able to help you, and you asked for help instead of an outright solution. DBForums sees far too many students asking us to do their homework for them, so it is really nice to see that there still are some good students!

Having done a very similar project for an AYSO region a few years ago, I can tell you that in an entire season, not a single "rich client" designed to run on a laptop ever returned data to the repository. This may have been biased because I wrote the beastie and used my cell phone to enter data, or because nearly every coach had a cell phone and only a few folks ever brought a laptop to a soccer pitch. The short answer is that the only data I ever got was from either HTTP or WAP, no data ever came from the application.

That doesn't mean that the laptop "rich client" application was useless. It could download and manipulate data, and was very useful at meetings.
<link drops removed -- use a real signature>

The one that is most in demand by employers and companies would be Microsoft Access because it is the most common database system out there. If you want to know more about different kinds though, you always have google. Google it up and see what u get.
<link drops removed -- use a real signature>

No doubt about it a Microsoft Server plus Access, would probably be the easiest for a newbie to make a DB driven webpage with. Because you can build it with WSIWIG tools. But it not very stable for a production webpage, costs a lot in licenses/ buying the
software, and just as easier killed by a newbie as it is setup.

MySQL plus PHP plus Apache on Linux is free, there are plenty of examples, and howto webpage around to help get started. I recommend this over the MS solution, and its probably used by at least as many employers.

For professionals, Oracle plus a JSP middleware server is often the way to go.

Microsoft Access because it is the most common database system out there

As a dba, working with mysql, postgresql, ms sql server and oracle, I wonder where you are making this assertion from...