Re: Database design

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you've done any database design at all you know the 'correct' database
design is the first one. By having separate tables for each element you get
a lot of benefits that the second design doesn't provide. A few things off
the top of my head.

- Easy to create dropdowns dynamically for Season and League - eliminates a
lot of typos, eliminates redundant data
- Easy to add information about Seasons and Leagues - adding additional
redundant fields to Team records would be bad
- Easier to select entries by Season and League because you will use numbers
(generated by a combo box usually) instead of searching for strings


"BaWork" <bawork@xxxxxxxxxxx> wrote in message
news:ujL71THmFHA.1044@xxxxxxxxxxxxxxxxxxxxxxx
> I'm working on a database for a web app and I'm stuck. What is better in
> the long run and what are the pros/cons of each design
>
> Version 1
>
> 4 tables: Organization, Season, League and Team
>
> Season is related to Organization, League is related to Season and Team
> is related to League.
>
> Organization Table
> org_id (primary)
> org_name
>
> Season Table
> season_id (primary)
> org_id
> season_name
>
> League Table
> league_id (primary)
> season_id
> league_name
>
> Team Table
> team_id (primary)
> league_id
> team_name
>
> OR
>
> Version 2
>
> 2 tables: Organization and Team
>
> Team is related to Organization
>
> Organization Table
> org_id (primary)
> org_name
>
> Team Table
> team_id (primary)
> org_id
> season
> league
> team_name
>
> Thanks
>
> Brett
> bawork@xxxxxxxxxxx


.

Relevant Pages

  • Re: Seeking some expert advice.
    ... select a league from three years ago and re-print all of the personal score ... > but you just need to have the TeamID field in the Members table; ... > get queries that will give you the desired records, to write foreign key ... > that your database design is not the best you could have. ...
    (microsoft.public.access.forms)
  • Automatic updates of a ranked table
    ... I want to take data from one spreadsheet to make a ranked table (soccer ... Is it possible to design it so that the league will ... automatically update when I enter ...
    (microsoft.public.excel.misc)
  • C# programmer looking for a job
    ... Software Development including Desktop, Client/Server and Database ... Practical skills in object oriented design and design patterns ... XML, Oracle, CVS, VSS, Delphi, bug tracking. ... Developed in Delphi5; ...
    (misc.immigration.usa)
  • Re: O/R Mapper
    ... | - create E/R model from niam model ... classes that contain, not only data, but also functionality as OO design is ... a database where they do not exist in the object model is corrupting the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Date range on reports
    ... > box to your report with a control source like: ... >> In the Database window (Database window: The window that appears when you ... >> In the New Form dialog box, click Design View, and click OK. ... >> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)