Flashcards
Key fields
Flashcards do 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
Informações
- Descrição
- A level ICT FlashCards sobre Key fields, criado por Leann McLeod em 23-02-2017.
- Criado por
- Leann McLeod · fev 2017
- Atualizado
- 23 fev 2017
- Visualizações
- 4
- Avaliação
Mais sobre Database Keys and Relationships