Re: Database Design

"Yanick Hudon" <yannik_at_sympatico.ca> wrote in message news:<OMQX6.27692$uR5.2255033_at_news20.bellglobal.com>...
> Hi all,
>
> I would like to get an advice on design rules that i got to create
> an application.
> It's about golf tournaments.
>
> Here are the rules:
>
> 1. I've got 4 contest: Longest drive men, Longest drive Women,
> Nearest hole men, nearest hole woman.
> Those contest are present in most of the tournaments, but not
> all.
>
> 2. I've got 2 tournaments that are teams tournaments.
> I want to keep track of the golfer name on each team.
>
> 3. Starting time tournaments:
> I've got many types, Shotgun, delayed times, ....
>
>
> Now here the way i defined:
>
> Tournaments Contest: Contests:
> TournamentID (fk) ContestID(pk)
> CourseID
> ContestTitle
> ContestID
> Description
> GolferID Comments
>
> TeamsTournaments: Teams Details
> TournamentID (fk) TeamID (pk)
> CourseID GolferID
> TeamID TeamClass
> Score
> Comments
> Comments
>
> Starting Times Starting Types
> TournamentID (fk)
> StartingTypeID(pk)
> CourseID Title
> StartingTypeID Description
> StartingID Comments
>
> Starting Times
> StartingID (pk)
> GolferID
> StartingHole
> StartingTime
>
> Now the questions are:
>
> 1. It seem to me that i have too much relations 1..M, doesn't it???
> 2. Also, it seem again that i have a lot of redundancy for the
> foreign keys, doesn't it???
>
> Any help or advice would be appreciated.
>
> Thanks in advance!

Hi,
I have created two Data Models for you on my Database Answers Web Site :-

   http://www.databaseanswers.com/data_models/golf_tournaments/index.htm

I suggest you have a look at the FACTs here :-

   http://www.databaseanswers.com/data_models/golf_tournaments/facts.htm

change them appropriately, and modify the Physical Data Model accordingly.

If you have any questions or problems, let me know.

Good luck

Barry Williams
Principal Consultant
Database Answers Received on Sat Aug 18 2001 - 16:55:24 CEST