Originally posted by honky tonk
Ahhh Ok, so is it right, though, that if you do have two tables, there would be one with a primary and foreign key, and another with just a foreign key?
Man, after typing that - I'm more confused than ever.
If you had two tables:
Table 1: primary key and foreign key
Table 2: foreign key (seen from Table 1), which is actually the primary key (seen from Table 2).
Each table has a primary key, but Table 1 (main/first) table sees or imports the primary key of the second, into a foreign key (by definition).
About the degrees of normalisation, just know 1NF (first norm form) and domain and key normal form (DKNF).
If you're confused, forget it, and stick to the definition of
normalisation
Degrees of normalisation is good to know, if you understand it, and if you don't, it won't matter too much, as it's not really tested or assumed knowledge.