Hi all,
i am desiging a database for a team
what i need from this data base keep record of all players, information about every player height , weight , age .. etc
and i need information on every game he played
and how many 2pts. how many 3pts. how many rebounds.. etc a player made.
can anybody help me in the design.
and tell me how many tables i should have, or send me a sketch diagram of the tables.
thanks in advance

Sounds like a homework assignment.

Life's more painless for the brainless.

I would do it as three tables:

TABLE 1 (PLAYER):

P_ID: A unique ID for the player
P_LASTNAME: Last name
P_FIRSTNAME: First name
P_HEIGHT: Height (in inches or metric, you can convert if you want to display feet)
P_WEIGHT: Weight
P_BIRTHDAY: Player's birthday, then calculate the age. That way the age displayed updates automatically.
etc.

TABLE_2: (GAME)
G_ID: ID of the game
G_DATE: Date game was played
G_TEAM: Name of opposing team
etc.

TABLE 3: (PLAYERS and GAMES)
P_ID: ID of the player
G_ID: ID of the game they played in
C_REBOUNDS: Rebounds
C_2PTS: 2 point shots
etc.