Solved

Table Normalization Part 2

Posted on 2004-04-28
11
156 Views
Last Modified: 2010-04-05
OK, to add onto previous question:

http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/Q_20968246.html

i think this design will work, but it will take some re-working of my existing application, any suggesions:

I will then post a question for SQL statements need to calculate points.

Thanx!

Shane



Teams
- id
- Name

Players
- id
- TeamId
- Name  
- Points - Calculated

Matches
- id
- Date
- Team1
- Team2

MatchResults
- id
- MatchId
- Team
- Points - Calculated Field

Games
 - Id
 - MatchId
 - MatchType - {Singles, Doubles}

GameResults
 - Id
 - GamesId
 - Player - Selected from Players
 - Points (not calculated)
0
Comment
Question by:shaneholmes
  • 9
  • 2
11 Comments
 
LVL 12

Expert Comment

by:esoftbg
ID: 10943685
May be:

Teams
- id
- Name
- Points - Calculated

Players
- id
- TeamId
- Name  
- Points - Calculated

Matches
- id
- Date
- Team1
- Team1Points - Calculated Field
- Team2
- Team2Points - Calculated Field

Games
 - Id
 - MatchId
 - MatchType - {Singles, Doubles}

GameResults
 - Id
 - GamesId
 - Player - Selected from Players
 - Points (not calculated)
0
 
LVL 11

Author Comment

by:shaneholmes
ID: 10943721
Yeah, i had that before in my original design - see link above
i dont belive its normalized that way - I ran into problems earlier trying to use it like that um then again, i dont know what my new sqls will be like

Shane
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 10943968
I think the fields Team1 and Team2 in the table Matches double the field Team in the table MatchResults:

Teams
- id
- Name
- Points - Calculated

Players
- id
- TeamId
- Name  
- Points - Calculated

Matches
- id
- Date

MatchResults
- id
- MatchId
- TeamId
- Points - Calculated Field

Games
 - Id
 - MatchId
 - MatchType - {Singles, Doubles}

GameResults
 - Id
 - GamesId
 - Player - Selected from Players
 - Points (not calculated)
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 12

Expert Comment

by:esoftbg
ID: 10944090
May be:

Matches
- id
- Date
- MatchType - {Singles, Doubles}

//.......................

Games
 - Id
 - MatchId
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 10944104
Here is 01:16 AM, I will go into the bed. Tomorrow will be a better day for programming :-))
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 10944123
Not tomorrow - today but after the dream....
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 10957995
I have not Access, so i developed a simple hint-example:
http://www.geocities.com/esoftbg/Q_20971121.zip
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 10958184
0
 
LVL 11

Author Comment

by:shaneholmes
ID: 10958871
esoftbg, im getting this message....

We're sorry, but this page is currently unavailable for viewing.
If this site belongs to you, please read this help page for more information and assistance.

Shane
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 10965585
0
 
LVL 12

Accepted Solution

by:
esoftbg earned 100 total points
ID: 10973327
I have no problems to download the file Q_20971121.zip as it is declared above, but you may visit
http://www.geocities.com/esoftbg/
and
http://www.geocities.com/eosoft/
first as a web-pages and then download from the link
Q_20971121.zip
Really I don't understand what happens with my yahoo web-pages. I can access them without problems, but you are the first, who alert me for "currently unavailable for viewing" message, but already is another who alert me about the same ????
These web-sites belong to me, but I don't know what to do for avoiding this problem.
emil
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PDF library for Delphi 2 120
URL for downloading Google Chrome for Win XP 2 152
Delphi Yen format 3 33
Not able to call Delphi XE10 dll function from Delphi 6.0 4 26
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question