Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Post First Year College Student. DESIGN Question!!!!PLZ

    My Idea is to have a database that will keep track of NHL scores, teams, players, and stats. Below are my rough designs. Can someone help me out to make this a better design?

    ERD (erd.gif) - I don't think this is accurate.
    Relationships (Relatiochip.gif) - I don't think this is acurate

    Please Feel free to post any comments\critisims.

    My course:Computer Programming
    Class: Introdution to Databases
    School: Algonquin College Ottawa
    Last edited by pere0076; 11-29-05 at 00:44.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    You're close. have a look here. The first thing that strikes me is you don't have internal keys for score, players or stats. The second red flag is you used teamname instead of teamid as a foriegn key to players. The third biggie is how you related players to stats.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •