| A | B |
|---|
| UID | unique Identifier |
| simpleUID | a UID that is a single attribute |
| composite UID | a UID that is a combination of attributes |
| artificial UID | a UID that does not occur in the natural world but is created for identification purposes in a system |
| candidate UID | a UID that identifies a person |
| primary UID | a candidate UID that is the primary identifier of a person |
| secondary UID | a candidate UID that also identifies a person, but is not the primary |
| first normal form | eliminates repeating groups by putting each into a seperate table and connecting them with a 1:M relationship |
| normalization | a series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database |
| second normal form | the output of thesecond step of database normilization |
| third normal form | the form of database normaliztion where all non key fields are dependent on the key. No none UID attributes can be dependent on another non UID attribute. |
| transitive dependency | a condition that exist when any attribute in an entity is dependent upon another non UID attribute in that entity |
