1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Rep Power

    Normalization problem

    player (plaerID, Pname, Pposition)
    team(team_ID, Division,Tname)

    position must be mid, goalkeeper, fwd or back
    division must be premier or 1st division...

    there are lot of repeatings when i enter data..
    how to normalize this. do i have to create tables for goal, mid, fwd and so on.. or is it ok to let it be lyk thiz.
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Toronto Canada
    Rep Power
    Originally Posted by ishan2ma
    is it ok to let it be lyk thiz.
    what is this, typing with your thumbs?

    you have no relationship between players and teams
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo