Hi all,
Now I have implemented my normalised database with my php code it seems that denormalising would be more efficient :S.
I have 3 tables for my asteroid control.
A main one with information about the user. Like "username"(primary) and resources password etc.
Then there is a table containing asteroids. With "asteroidID"(primary), "type", "mass", "distance"
Then I have a table to assign ownership of asteroids to users. with just 2 fields both primary keys.
"username" and "asteroidID"
There are other tables that link to the "asteroidID" like the mining table indicated which is being mined.
When I come to delete the asteroid is added work with the username to asteroidID link table. Whats the advantage of doing it the way I have which is following normalisation rule over the easier solution which is to remove the link table and put the username field into the asteroid table.?
Thanks