Flashcards
Key fields
Cards in this deck (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
Information
- Description
- A level ICT Flashcards on Key fields, created by Leann McLeod on 23/02/2017.
- Created by
- Leann McLeod · Feb 2017
- Updated
- Feb 23, 2017
- Views
- 4
- Rating
More on Database Keys and Relationships