How to create this database?

Question

I want to create a database that can be used for an archery club
I have the data I need, I'm just not sure how to put it all together.

The database needs to be able to have new members to the club be able to join,
then we are divvied up in to sex, age group and bow type.
(2 sexes, 6 age groups, 5 bow types = 60 groups)

I also want to be able to enter the competitions shot, to determine Personal Bests,
Archery also runs off a rating system and depending on which group you're in each group has a required rating to receive a class (medal) as something to strive for.
So for each competition I want the database to show PB, Rating and Class (if achieved)

I know it is creatable as there is an old system the club uses, however the class system has changed and either the ratings have too, or the clubs current system is incorrect.
Either way, I'd like to recreate it now, but do not have access to the files used to create the old one and need to start from scratch.


As a mock up, I have worked out in MS Excel ('07) the formulas needed to generate PB ---> Rating ---> Class.

But im unsure on how to make the document find the correct age group and bow type, for a person, without having to retype the formulas for that person.

Thanks for any help you can provide, even if its just pointing me to a book or website that could teach me

Answer 1

To create Database in Xampp : variety on your browser (Ie, Mozilla, in spite of the fact that): localhost interior the left area pick: phpmyadmin There you may create your database an person with the privilages you prefer. to connect with that database in own abode page is something like this: $dbhost = 'localhost'; //host $dbuser = 'root'; //your username created $dbpass = 'password'; //the password 4 that person $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('blunders connecting to mysql'); $dbname = 'petstore'; mysql_select_db($dbname);//your database. additionally this is sturdy which you heave a configuration.own abode page document which includes the: host, person, pasw, call -s.

Answer 2

MS Access may be a point to start with, personally I do not like it as it is a bit bloated.

You will need to get some knowledge in the following areas:

1. General SQL commands and syntax(regardless of what dialect, they only differ slightly)

- how to create tables

- how to use SELECT statements, including JOIN, GROUP and WHERE clauses

- normalisation of tables

Searching the web for "sql tutorial" and/or any of the above keywords should give plenty results to get you started with this.



2. A way to create a GUI to interact with your database, as you later will not want to INSERT or SELECT data from your table by typing SQL-statements, but by clicking buttons.

MS Access already offers this, but as mentioned, it is not for me - you may get along with it though.

Alternatives are:

- XAMPP which installs a local MySQL Database and Webserver on your PC. You manage your databases with phpmyadmin and also can access your db using html and php. If you already have some background knowledge there, this is the way to go. It also allows you to later simply move your db to a webserver to access it from anywhere over the web.

- SQLITE database. There is a great addon for Mozilla Firefox called Sqlite Manager (currently version 0.8). It it easy to install and allows to work with sql tables right aways. This can help a lot to learn the sql commands from 1., as you can directly enter them here and see the results (you can do the same with phpmyadmin, but that takes a bit longer to setup).

Getting a GUI for SQLITE is a bit trickier, there are many programming languages that offer connectors to sqlite databases such as MS Visual C#. It gives complete freedom of how you can design your program, but may be overkill for your scenario.



3. An exact understanding of what data there is to be stored in your scenario, how the processes work, what you later want to be able to do with that data and how this can be done using SQL.

This topic is closely linked to 1., especially to normalisation of tables.

Answer 3

Good day Sir!



for none programmers, Microsoft Access is the best for these because it is really a friendly user data base.



you may also you use SQL as it is the basic database language. :)





hope these helps! :3





Please rate us :3 Thanks!