3NF or BCNF?

Discussion in 'Database' started by numberone, Nov 26, 2007.

  1. numberone

    numberone New Member

    Joined:
    Nov 26, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    hi, is the following table in 3NF and BCNF (boyce codd normal form)?

    PL(Team, played, Won, Draws, Lost, goals-scored, goals-against, Points)

    I mean, its purpose seems simple enough, but it is confusing to me either whether its possible to decompose it to BCNF.
    anyone got any clues??

    x
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Every database design with respect to some context and so you should let us know what you are trying to store in the tabled and what each column is all about.
     
  3. numberone

    numberone New Member

    Joined:
    Nov 26, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Well, the purpose of the database is to store information on a football,soccer league, stating the facts and figures about the teams. For example dta would be updated accordingly for if a team would play a game and score 2 goals, the played column would increase 1 and the goals would increase by 2. Sorry for my bad description, heres a table .

    Team, played, Won, Draws, Lost, goals-scored, goals-against, Points
    England, 8, 7, 1, 0, 19, 6, 22
    Brazil, 9, 6, 2, 1, 11, 2, 20

    hope my question is abit clearer.
     
  4. numberone

    numberone New Member

    Joined:
    Nov 26, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    sorry i dont know how to edit the post, i forgot to mention

    team = team name
    played = how many games a team has played
    won = how many games a team has won
    draws = how many games a team has drawed
    lost = how many games a team has lost
    goals- scored = how many goals a team has scored
    goals-against = how many goals they have conceived
    points = there points on the table is determined by all the previous attributes.
     
  5. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Read the welcome email and it says when you can edit your own posts and its after 25 posts.

    Now about your query. I think your table structure is in 3 NF provided your team is the unique key.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice