Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   3NF or BCNF? (http://www.go4expert.com/forums/3nf-or-bcnf-t7552/)

numberone 26Nov2007 23:18

3NF or BCNF?
 
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

shabbir 26Nov2007 23:28

Re: 3NF or BCNF?
 
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.

numberone 26Nov2007 23:41

Re: 3NF or BCNF?
 
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.

numberone 26Nov2007 23:47

Re: 3NF or BCNF?
 
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.

shabbir 27Nov2007 09:08

Re: 3NF or BCNF?
 
Quote:

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.


All times are GMT +5.5. The time now is 15:19.