Results 1 to 2 of 2

Thread: Student Help

  1. #1
    Join Date
    Jul 2014
    Posts
    1

    Unanswered: Student Help

    This might be so far below every professional here but i'm taking an accelerated database management course and could really use help on the final project.

    Again super simple stuff but would be really awesome if i could pick someone's brain.

    I'm working on my database and finding that bad decisions i've made along the way have compounded and made queries and forms hard to produce. I currently have:

    Player (*PlayerName, DateOfBirth, AllStarAppearances, PreviousYearsSalary, ExpectedSalary)
    Team (*TeamName, Payroll, PreviousYearWinPct, Championships, FranchiseOrigin, StadiumName)
    Stadium (*StadiumName, Location, DateFounded, TotalRevenue, TeamName)

    My idea is that players who are currently seeking a new team factor in a lot of things in making their choice. So a free agent player may choose a team based on its location and history or choose a team based on winning pct or payroll.

    In working with the relationships I had a 1:M relationship between Player to Team and 1:1 Team to Stadium. Because a player can choose a number of teams, but the teams are tied to their stadiums and vice versa.

    I imagined the kind of queries i could make are average age of teams that pick based on winpct or allstar apps related to championships.

    Is there a better way to set all this up?

    Potential Thanks
    jah

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    You need changes...TeamHist

    Team (*TeamName, Payroll, FranchiseOrigin, StadiumName)
    TeamHist (*TeamHistID, TeamName, Year, WinPct,ChampionShip)
    and/or
    TeamEvent(TeamEventID,TeamName, GameDate, TeamScore, OppScore, WinLost)

Tags for this Thread

Posting Permissions

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