What are the differences between super key primary key candidate key and foreign key?

1 answer

Answer

1244411

2026-10-15 01:45

+ Follow

  • Super key: A set of attributes that uniquely identifies a tuple in a table.
  • Primary key: A specific super key chosen to uniquely identify each tuple in a table and must be unique and not null.
  • Candidate key: Any super key that could be chosen as the primary key.
  • Foreign key: A field in a table that is a primary key in another table, used to establish a relationship between the two tables.

ReportLike(0)ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.