Help shape GoConqr. What should we add next?

Flashcards

Key fields

Leann McLeod ICT A level English 3 cards

Cards in this deck (3)

  1. 1Primary Key- unique identifier for each record in table
    - must not have any repeating values
    - must never change
  2. 2Compound Key- 2 or more fields combined to form a unique indentity
    - don't use in relational database design
    - is complicated stuff
  3. 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

Feedback

What is it about?

What should we add next?