Karteikarten
Key fields
Karten in diesem Stapel (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
Informationen
- Beschreibung
- A level ICT Karteikarten am Key fields, erstellt von Leann McLeod am 23/02/2017.
- Erstellt von
- Leann McLeod · Feb 2017
- Aktualisiert
- 23 Feb 2017
- Aufrufe
- 4
- Bewertung
Mehr zu Database Keys and Relationships