Define candidate key, alternate key, composite key.

Author Topic: Define candidate key, alternate key, composite key.  (Read 4474 times)

Offline beingchinmayTopic starter

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 1
  • Posts: 73
  • Karma: 0
  • Gender: Male
  • I am Chinmay
    • Modular Kitchen Designer
candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table. If the table has more than one candidate key, one of them will become the primary key, and the rest are called alternate keys. A key formed by combining at least two or more columns is called composite key.


 

Related Topics

  Subject / Started by Replies Last post
2 Replies
2556 Views
Last post 11-14-2012, 08:09:49
by dave-o99
6 Replies
6849 Views
Last post 04-20-2016, 00:06:27
by Kate Evans
15 Replies
10382 Views
Last post 05-15-2016, 23:03:10
by jaysh4922
2 Replies
4523 Views
Last post 03-26-2021, 02:25:07
by Lishmalinyjames
0 Replies
2074 Views
Last post 05-12-2016, 06:12:54
by chinmay.sahoo