Keys...

• Can use the UNIQUE keyword in same way

  • …but for any number of attributes
  • foreign key only reference PRIMARY KEY

• Indexing Keys

CREATE UNIQUE INDEX YearIndex ON Movie(year)

• Makes insertions easier to check for key constraints

• Subtle differences between PRIMARY KEY and UNIQUE

Previous slide

Next slide

Back to first slide

View graphic version