what is candidate key & primary key,different b/t the two?
- 3 Answers
- 4890 Views
- I also Faced
- E-Mail Answers
Answer Posted / uday shankar dokku
candidate key: when we reduce unnecessary columns from a
super key it is called as candidate key
primary key: primary key is a constraint, in a table
there is only one primary key,a primary key is simple or
composite, a simple primary key is based on one column which
can be specified either inline outline of the constraint,a
composite primary key is based on (2-32)columns which can
be specified only out line of the constraint,a primary dose
not allows duplicates.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is 1nf in the dbms?
Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?
What are the disadvantages of a database?
What is the relationship?
What are stand-alone procedures?
How many rows can a database hold?
What are database modules?
What are the 5 databases?
How do you exit a database?
Is there a database program for mac?
What is the best database management system?
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
Is file system a database?
Explain atomicity and aggregation?
What are the advantages of database management system?
