By definition a primary key is unique.
In order to make this table into 3rd normal form (which most db tables should be), you need to take anyon extra info that appears multiple times and put it into a table where it exists ONCE.
That info should have a unique identifier (ie, the primary key) that is used in another table to connect it to related fields.
In your case, you should have something like:
identifier1(primary key)|AD01|123mania|adaware.....
in one table and then create another table with
identifier2(primary key)|identier1(foriegn key from above)|SpySweeper
etc.
The foreign key in your second table is the key to linking the data.
You could also do it like you suggested by creating another field, but I suspect you would get points knocked off since the proper way to do it is to create another table.
__________________
"Of all tyrannies, a tyranny exercised for the good of its victims may be the most oppressive. It may be better to live under robber barons than under omnipotent moral busybodies. The robber baron's cruelty may sometimes sleep, his cupidity may at some point be satiated; but those who torment us for our own good will torment us without end, for they do so with the approval of their own conscience." – C. S. Lewis
The ONLY sponsors we have are YOU!
Please Donate!
|