Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

waht is the difference between primary key and super key?

Answer Posted / sweety singh

superkey is a set of attributes that can uniquely identify
individual tuples whereas a key or a primary key is a
minimal super key that can identify individual tuples.
ex..eno pno hrs
1 1 2
2 4 7

i.e...here eno,pno,hrs together are a superkey but eno,pno
is primary key and hence eno,pno cant hav null values and
repeated enteries....

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to pass parameters to procedures in oracle?

993


How do I manually uninstall oracle client?

1023


How to create tables for odbc connection testing?

1008


What are the execution control statements?

1015


What is an oracle data file?

1035


What is ceil and floor in oracle?

1007


Explain temporal data types in oracle

1040


What are the major difference between truncate and delete?

979


What are oracle functions?

974


What is a nvl function?

956


List out the difference between commit, rollback, and savepoint?

985


what is reindexing?

1609


How to shutdown your 10g xe server from command line?

1014


How to omit columns with default values in insert statement in oracle?

995


How do I limit the number of oracle database connections generated by weblogic server?

1006