reset password
Author Message
304449449
Posts: 10
Posted 00:24 Apr 29, 2016 |

dr sun can u please tell me what does a super key mean? what is the difference between primary key and super key? and what is the use of the super key?

 

Thank You

Sumanth Shankar

cysun
Posts: 2935
Posted 10:18 Apr 29, 2016 |

The definition of super key is on Slide #15 of the lecture notes.

It has very little to do with primary key (other than the fact that they both have something to do with keys).

It's used in determining whether a table is BCNF.

304449449
Posts: 10
Posted 23:03 Apr 29, 2016 |

thanks a lot dr sun for the reply.