Database

[Champions_2002]

Hi i'm trying to make a soccer game and was wondering if anybody could help me with a few things that im stuck on

1.I want to make a database with all the teams and players, with the players skils on it? How do i do that

2.I want to make a fixture list with a different number of teams in there i.e England Premier 20 teams, France 18 and so on

thanks

[Mitthrawnuruodo]

Can you give source that you started on?

[Moneo]

If you wanted to make a real database, you would have to do it using a database language like SQL, DB2 or worst case a pseudo database like Access.

Since this forum is about Qbasic, QuickBasic and FreeBasic, I assume you're going to write your program in one of these closely related languages.

Therefore, your "database" will most probably be a flat-file, otherwise known as a text file. You can use sequential or random or binary access for the file.

Taking a pure text file as an example, you could design each record as follows:
* Positions 01-40: The name of a team. Use a name that is unique and distinguishes the team.
* Positions 41-80: The name of a player. Last name, First name would be the best. For duplicates within same team, add a unique numeric code on the end.
* Positions 81-90: One or more (max 10) single alphabetic codes for the player's skills. Example: A is a skill, B is another skill, so on for 10 possible skills. A player with all 10 skills would have ABCDEFGHIJ in positions 81-90 of the record. You make up the skill codes and what they mean.

You probably won't want to write a program to maintain (add, change, or delete) records from this file, so you can carefully maintain it with your favorite editor.

Based on a reasonable amount of teams and players, you could probably read the entire file into an array to be used by your program.

I hope I gave you a start.

I don't know what you mean by a "fixture list".
*****