Originally Posted by numberone
sorry i dont know how to edit the post, i forgot to mention
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.