Fichas
Key fields
Fichas del conjunto (3)
- 1Primary Key- unique identifier for each record in table
- must not have any repeating values
- must never change - 2Compound Key- 2 or more fields combined to form a unique indentity
- don't use in relational database design
- is complicated stuff - 3Foreign key- refers to the primary key in another table
- must be the same data type and field size as the primary being linked to
- F. key will alwatys link to a single primary key field
Información
- Descripción
- A level ICT Fichas sobre Key fields, creado por Leann McLeod el 23/02/2017.
- Creado por
- Leann McLeod · feb 2017
- Actualizado
- 23 feb 2017
- Visitas
- 4
- Valoración
Más sobre Database Keys and Relationships