First page Back Continue Last page Image

The 2 Main Types Of Keys

  • Sales
  • Key
  • Field
  • Type
  • PK
  • TID
  • TDate
  • TAmt
  • TClrk
  • FK
  • CNumb
  • FK
  • PNumb
  • Product
  • Key
  • Field
  • Type
  • PK
  • PNumb
  • PName
  • PInvt
  • PCost
  • Customer
  • Key
  • Field
  • Type
  • PK
  • CNumb
  • CName

A Primary Key (PK) is used to uniquely identify every record in a table

A Foreign Key (FK) is used to link a table to another tables Primary Key