Define candidate key, alternate key, composite key.
Define candidate key, alternate key, composite key.
View Answers
November 15, 2010 at 5:45 PM
Hi,
Here is the answer,
candidate key- A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table.
alternate keys- Any of the candidate keys that is not part of the primary key is called an alternate key.
composite key- A key formed by combining at least two or more columns is called composite key.
Thanks.
Related Tutorials/Questions & Answers:
Define candidate key, alternate key, composite key.
Define candidate key, alternate key, composite key. Define candidate key, alternate key, composite key
Define candidate key, alternate key, composite key. Define candidate key, alternate key, composite key
ModuleNotFoundError: No module named 'vizion-composite-key'
ModuleNotFoundError: No module named 'vizion-composite-key' Hi...: No module named 'vizion-composite-key' How to remove the ModuleNotFoundError: No module named 'vizion-composite-key' error? Thanks Hi
ModuleNotFoundError: No module named 'vizion-composite-key' Hi...: No module named 'vizion-composite-key' How to remove the ModuleNotFoundError: No module named 'vizion-composite-key' error? Thanks Hi
Advertisements
hibernate annotations with composite primary key
hibernate annotations with composite primary key I want to know how to use hibernate annotations in case of composite primary key in one table. I... created a composite primary key with all the columns of the table. table
hibernate annotations with composite primary key I want to know how to use hibernate annotations in case of composite primary key in one table. I... created a composite primary key with all the columns of the table. table
primary key and unique key
primary key and unique key hello, What's the difference between a primary key and a unique key? hii,ADS_TO_REPLACE_1 Unique key.... Primary key: columns entry of duplicate as well as null values are restricted
primary key and unique key hello, What's the difference between a primary key and a unique key? hii,ADS_TO_REPLACE_1 Unique key.... Primary key: columns entry of duplicate as well as null values are restricted
Define sequence generated primary key in hibernate
Define sequence generated primary key in hibernate How to define sequence generated primary key in hibernate? Use value "sequence" for class attribute for generator tag. <id column="USER_ID" name="id" type
Define sequence generated primary key in hibernate How to define sequence generated primary key in hibernate? Use value "sequence" for class attribute for generator tag. <id column="USER_ID" name="id" type
How to design key, design key, key
How to design key It has been made easy now to design a key by this example, just..._TO_REPLACE_1 Pen Tool: Take "cccccc" color and choose Pen tool (P key), Make
How to design key It has been made easy now to design a key by this example, just..._TO_REPLACE_1 Pen Tool: Take "cccccc" color and choose Pen tool (P key), Make
In Composite Key Insertion Operation why the POJO class should implement Seriliazalbe interface?
In Composite Key Insertion Operation why the POJO class should implement Seriliazalbe interface? In normal primary key insertion operation pojo... of Composite Key Insertion Operation why the POJO class should implement Seriliazalbe
In Composite Key Insertion Operation why the POJO class should implement Seriliazalbe interface? In normal primary key insertion operation pojo... of Composite Key Insertion Operation why the POJO class should implement Seriliazalbe
What is a "primary key"?
are used as a primary key, they are called a composite key. Thanks...What is a "primary key"? What is a "primary key"? Hi, Here is the answer,ADS_TO_REPLACE_1 A primary key is used to uniquely identify
are used as a primary key, they are called a composite key. Thanks...What is a "primary key"? What is a "primary key"? Hi, Here is the answer,ADS_TO_REPLACE_1 A primary key is used to uniquely identify
difference between a primary key and a unique key?
difference between a primary key and a unique key? What's the difference between a primary key and a unique key? Hi, The column holding the primary key constraint cannot accept null values.whereas column holding
difference between a primary key and a unique key? What's the difference between a primary key and a unique key? Hi, The column holding the primary key constraint cannot accept null values.whereas column holding
Automatic key press
Automatic key press Hi Please any one help me is it possible automatic key press in j2me
Automatic key press Hi Please any one help me is it possible automatic key press in j2me
ModuleNotFoundError: No module named 'key'
ModuleNotFoundError: No module named 'key' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'key' How to remove the ModuleNotFoundError: No module named 'key' error
ModuleNotFoundError: No module named 'key' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'key' How to remove the ModuleNotFoundError: No module named 'key' error
KEY EVENT HANDLING
KEY EVENT HANDLING I am trying to write a program that receives every key stroke even when the window is not active or it's minimized. Is there anyway to do
KEY EVENT HANDLING I am trying to write a program that receives every key stroke even when the window is not active or it's minimized. Is there anyway to do
Foreign key update table
Foreign key update table How to update table that has the foreign key in SQL..? ALTER TABLE YourTable ADD CONSTRAINT FK_YourForeignKey FOREIGN KEY (YourForeignKeyColumn) REFERENCES YourPrimaryTable
Foreign key update table How to update table that has the foreign key in SQL..? ALTER TABLE YourTable ADD CONSTRAINT FK_YourForeignKey FOREIGN KEY (YourForeignKeyColumn) REFERENCES YourPrimaryTable
java key value pair
java key value pair Hi, How to save the java key value pair in Java? Thanks Hi, You can use the Hashtable for this purpose. Check the tutorial Creating a Hash Table. Thanks
java key value pair Hi, How to save the java key value pair in Java? Thanks Hi, You can use the Hashtable for this purpose. Check the tutorial Creating a Hash Table. Thanks
composinte primary key in hibernate
composinte primary key in hibernate I am facing following problem, Inside the database(mssql), i have created a table without primary key. After doing hibernate reverse engineering, by default it has taken composite
composinte primary key in hibernate I am facing following problem, Inside the database(mssql), i have created a table without primary key. After doing hibernate reverse engineering, by default it has taken composite
foreign key error in sql
foreign key error in sql create table matchdetails(mid varchar2(10...), stadium varchar2(10),city varchar2(10),mom varchar2(10),primary key(mid,mdate... varchar2(10),sixes varchar2(10),primary key(mid.pid), foreign key(mid
foreign key error in sql create table matchdetails(mid varchar2(10...), stadium varchar2(10),city varchar2(10),mom varchar2(10),primary key(mid,mdate... varchar2(10),sixes varchar2(10),primary key(mid.pid), foreign key(mid
registration key - Java Beginners
registration key I want the serial key for JCreator Pro 4.50. I lost it. If any body has it please send
registration key I want the serial key for JCreator Pro 4.50. I lost it. If any body has it please send
Foreign key in mysql
Foreign key in mysql Hi I am creating a website and linking it to a database using php and mysql. I need to create the databases in phpmyadmin... the foreign key of one table into another table within phpmyadmin so the database
Foreign key in mysql Hi I am creating a website and linking it to a database using php and mysql. I need to create the databases in phpmyadmin... the foreign key of one table into another table within phpmyadmin so the database
hibernate Foreign key
(255) DEFAULT NULL, City varchar(255) DEFAULT NULL, PRIMARY KEY (P_Id...) NOT NULL, OrderNo int(11) NOT NULL, P_Id int(11) DEFAULT NULL, PRIMARY KEY (O_Id), KEY P_Id (P_Id), CONSTRAINT orders_ibfk_1 FOREIGN KEY (P_Id) REFERENCES
(255) DEFAULT NULL, City varchar(255) DEFAULT NULL, PRIMARY KEY (P_Id...) NOT NULL, OrderNo int(11) NOT NULL, P_Id int(11) DEFAULT NULL, PRIMARY KEY (O_Id), KEY P_Id (P_Id), CONSTRAINT orders_ibfk_1 FOREIGN KEY (P_Id) REFERENCES
Key requirement for business analyst
Key requirement for business analyst What are the key requirement of the business analyst? A Business analyst plays a key role... of the key requirements for business analyst are mentioned below: Good
Key requirement for business analyst What are the key requirement of the business analyst? A Business analyst plays a key role... of the key requirements for business analyst are mentioned below: Good
what is key in kafka?
what is key in kafka? Hi, I was searching for Big Data jobs on internet and almost all the Big Data Job recruiters are asking for Kafka skills. what is key in kafka? How to learn Kafka? Thanks Hi, Yes in most
what is key in kafka? Hi, I was searching for Big Data jobs on internet and almost all the Big Data Job recruiters are asking for Kafka skills. what is key in kafka? How to learn Kafka? Thanks Hi, Yes in most
Ho to get virtual key code.
Ho to get virtual key code. Hi How to get virtual key code from button.I made on screen keyboard.But it not proper work for windows ,shift,alt and ctrl key. pls suggest me
Ho to get virtual key code. Hi How to get virtual key code from button.I made on screen keyboard.But it not proper work for windows ,shift,alt and ctrl key. pls suggest me
Mysql Alter Foreign Key
Mysql Alter Foreign Key A Foreign Key is a field that marks to the primary key of another table. The use of the foreign key is used to ensure referential
Mysql Alter Foreign Key A Foreign Key is a field that marks to the primary key of another table. The use of the foreign key is used to ensure referential
in this coding even backspace key and enter key should accept....
in this coding even backspace key and enter key should accept.... in this coding even backspace key and enter key should accept....plez help me and make changes to which it accept backspace and enter key ....plez plez plez its
in this coding even backspace key and enter key should accept.... in this coding even backspace key and enter key should accept....plez help me and make changes to which it accept backspace and enter key ....plez plez plez its
ModuleNotFoundError: No module named 'ava-key'
ModuleNotFoundError: No module named 'ava-key' Hi, My Python...-key' How to remove the ModuleNotFoundError: No module named 'ava-key... to install padas library. You can install ava-key python with following command
ModuleNotFoundError: No module named 'ava-key' Hi, My Python...-key' How to remove the ModuleNotFoundError: No module named 'ava-key... to install padas library. You can install ava-key python with following command
ModuleNotFoundError: No module named 'NFC-Key'
ModuleNotFoundError: No module named 'NFC-Key' Hi, My Python...-Key' How to remove the ModuleNotFoundError: No module named 'NFC-Key... to install padas library. You can install NFC-Key python with following command
ModuleNotFoundError: No module named 'NFC-Key' Hi, My Python...-Key' How to remove the ModuleNotFoundError: No module named 'NFC-Key... to install padas library. You can install NFC-Key python with following command
ModuleNotFoundError: No module named 'openssh-key'
ModuleNotFoundError: No module named 'openssh-key' Hi, My Python... 'openssh-key' How to remove the ModuleNotFoundError: No module named 'openssh-key' error? Thanks Hi, In your python environment
ModuleNotFoundError: No module named 'openssh-key' Hi, My Python... 'openssh-key' How to remove the ModuleNotFoundError: No module named 'openssh-key' error? Thanks Hi, In your python environment
ModuleNotFoundError: No module named 'openssh-key'
ModuleNotFoundError: No module named 'openssh-key' Hi, My Python... 'openssh-key' How to remove the ModuleNotFoundError: No module named 'openssh-key' error? Thanks Hi, In your python environment
ModuleNotFoundError: No module named 'openssh-key' Hi, My Python... 'openssh-key' How to remove the ModuleNotFoundError: No module named 'openssh-key' error? Thanks Hi, In your python environment
ModuleNotFoundError: No module named 'py-key'
ModuleNotFoundError: No module named 'py-key' Hi, My Python...-key' How to remove the ModuleNotFoundError: No module named 'py-key'... to install padas library. You can install py-key python with following command
ModuleNotFoundError: No module named 'py-key' Hi, My Python...-key' How to remove the ModuleNotFoundError: No module named 'py-key'... to install padas library. You can install py-key python with following command
ModuleNotFoundError: No module named 'ava-key'
ModuleNotFoundError: No module named 'ava-key' Hi, My Python...-key' How to remove the ModuleNotFoundError: No module named 'ava-key... to install padas library. You can install ava-key python with following command
ModuleNotFoundError: No module named 'ava-key' Hi, My Python...-key' How to remove the ModuleNotFoundError: No module named 'ava-key... to install padas library. You can install ava-key python with following command
ModuleNotFoundError: No module named 'django-key'
ModuleNotFoundError: No module named 'django-key' Hi, My Python... 'django-key' How to remove the ModuleNotFoundError: No module named 'django-key' error? Thanks Hi, In your python environment you
ModuleNotFoundError: No module named 'django-key' Hi, My Python... 'django-key' How to remove the ModuleNotFoundError: No module named 'django-key' error? Thanks Hi, In your python environment you
ModuleNotFoundError: No module named 'key-logger'
ModuleNotFoundError: No module named 'key-logger' Hi, My Python... 'key-logger' How to remove the ModuleNotFoundError: No module named 'key... have to install padas library. You can install key-logger python
ModuleNotFoundError: No module named 'key-logger' Hi, My Python... 'key-logger' How to remove the ModuleNotFoundError: No module named 'key... have to install padas library. You can install key-logger python
ModuleNotFoundError: No module named 'key-mon'
ModuleNotFoundError: No module named 'key-mon' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'key-mon' How to remove the ModuleNotFoundError: No module named 'key-mon
ModuleNotFoundError: No module named 'key-mon' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'key-mon' How to remove the ModuleNotFoundError: No module named 'key-mon
ModuleNotFoundError: No module named 'key_note'
ModuleNotFoundError: No module named 'key_note' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'key_note' How to remove the ModuleNotFoundError: No module named 'key_note
ModuleNotFoundError: No module named 'key_note' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'key_note' How to remove the ModuleNotFoundError: No module named 'key_note
ModuleNotFoundError: No module named 'key-train'
ModuleNotFoundError: No module named 'key-train' Hi, My Python... 'key-train' How to remove the ModuleNotFoundError: No module named 'key... have to install padas library. You can install key-train python with following
ModuleNotFoundError: No module named 'key-train' Hi, My Python... 'key-train' How to remove the ModuleNotFoundError: No module named 'key... have to install padas library. You can install key-train python with following
ModuleNotFoundError: No module named 'key-typeddict'
ModuleNotFoundError: No module named 'key-typeddict' Hi, My... 'key-typeddict' How to remove the ModuleNotFoundError: No module named 'key-typeddict' error? Thanks Hi, In your python
ModuleNotFoundError: No module named 'key-typeddict' Hi, My... 'key-typeddict' How to remove the ModuleNotFoundError: No module named 'key-typeddict' error? Thanks Hi, In your python
JavaScript Key Event
on the text field2 on key up. For this purpose, we have created two text fields text1 and text2. On pressing the key to write the text on the textbox1, you... by using the onkeyup event. It occurs when a keyboard key is released.ADS
on the text field2 on key up. For this purpose, we have created two text fields text1 and text2. On pressing the key to write the text on the textbox1, you... by using the onkeyup event. It occurs when a keyboard key is released.ADS
Missing message for key tenant.lbl - Struts
Missing message for key tenant.lbl I have properties file with key value pair.I am trying to get that value int jsp by using tag.In struts-config.xml I placed below code still I am getting Missing message for key tenant.lbl.
Missing message for key tenant.lbl I have properties file with key value pair.I am trying to get that value int jsp by using tag.In struts-config.xml I placed below code still I am getting Missing message for key tenant.lbl.
Hibernate unique key validation example
Hibernate unique key validation example Hi, How to preform unique key validation in Hibernate application? Thanks Hi, You write a program to check for the presence of the key in database before performing add
Hibernate unique key validation example Hi, How to preform unique key validation in Hibernate application? Thanks Hi, You write a program to check for the presence of the key in database before performing add
setValue:forUndefinedKey:]: this class is not key value coding-compliant for the key headerView.
setValue:forUndefinedKey:]: this class is not key value coding-compliant for the key headerView. HI, In my iPhone application I am getting following error: setValue:forUndefinedKey:]: this class is not key value coding
setValue:forUndefinedKey:]: this class is not key value coding-compliant for the key headerView. HI, In my iPhone application I am getting following error: setValue:forUndefinedKey:]: this class is not key value coding
how tohow to create a table with primary key and foreign keyhow to create a table with primary key and foreign key
how tohow to create a table with primary key and foreign keyhow to create a table with primary key and foreign key how to create a table using java language with primary key and foreign key Hi Friend, A foreign
how tohow to create a table with primary key and foreign keyhow to create a table with primary key and foreign key how to create a table using java language with primary key and foreign key Hi Friend, A foreign
Create primary key using hibernate
Create primary key using hibernate How to create primary key using hibernate? The id element describes the primary key for the persistent class and how the key value is generated. ADS_TO_REPLACE_1
Create primary key using hibernate How to create primary key using hibernate? The id element describes the primary key for the persistent class and how the key value is generated. ADS_TO_REPLACE_1
J2ME Key Codes Example
J2ME Key Codes Example This application illustrates how to print the key value with the current key pressed on the canvas. In this application we are using the keyPressed
J2ME Key Codes Example This application illustrates how to print the key value with the current key pressed on the canvas. In this application we are using the keyPressed
Adding A Primary Key to an Existing Table
Adding A Primary Key to an Existing Table Been trying to add a primary key to a MySQL table using Java for two days with no success. I'm new... KEY (SerialNo)"); out.println("Primary key added
Adding A Primary Key to an Existing Table Been trying to add a primary key to a MySQL table using Java for two days with no success. I'm new... KEY (SerialNo)"); out.println("Primary key added
code for image to key generation - JDBC
code for image to key generation plz help me how cud i convert image into key using sha1 algorithm in java.... plz give me the code to write it... i m doing image based registration
code for image to key generation plz help me how cud i convert image into key using sha1 algorithm in java.... plz give me the code to write it... i m doing image based registration
crud operations with foreign key constraint.
crud operations with foreign key constraint. I neeed to know how to perform crud operations in mysql with foreign key constraint using mvc architecture i.e using servlet jsp and bean. please provide all the code so that i can
crud operations with foreign key constraint. I neeed to know how to perform crud operations in mysql with foreign key constraint using mvc architecture i.e using servlet jsp and bean. please provide all the code so that i can
Ads