Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
very simple SQL design question
Name: DataFlood Date: May 1, 2008 at 21:02:20 Pacific OS: vista CPU/Ram: 4gb Product: HP Pavilion
Comment:
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
Name: Jennifer SUMN Date: May 2, 2008 at 12:08:39 Pacific
Reply:
Sounds like a homework assignment.
Life's more painless for the brainless.
0
Response Number 2
Name: boaster Date: May 2, 2008 at 14:33:46 Pacific
Reply:
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.
0
Response Number 3
Name: qualsoft Date: December 11, 2008 at 23:25:53 Pacific
Summary: Hey everyone, im taking an SQL class and im working on my first assignment. It seems simple but i keep getting an Error 1062, duplicate entry '1' for key 1. I have no idea what im doing wrong here. He...
Summary: Hello all, My apologies if this has been answered previously, but I could not find anything specific enough to answer my question. I dare say it will be a very simple solution anyway. I am working wit...
Summary: I have two databases. Very simple databases, basic data entry, no links to tables or formulas or anything of the sort. Some employees were entering data into db and others into another. Some were ente...
0 
