Keys in DBMS

Ads

 
 

Share on Google+Share on Google+

Samuel A.
Keys in DBMS
1 Answer(s)      6 years and 6 months ago
Posted in : SQL

Whats the main difference between composite and super keys

Ads
View Answers

April 29, 2011 at 10:53 AM


Difference between super key and composite key:

A super key is a set of columns within a table that can be used to identify a particular row in a table while composite key is the combination of two or more than two keys which identifies entities uniquely.


Ads









Related Tutorials/Questions & Answers:
Keys in DBMS
Keys in DBMS  Whats the main difference between composite and super keys   Difference between super key and composite key: A super key... in a table while composite key is the combination of two or more than two keys
Advertisements
setting keys
setting keys  Hi Sir\Mam,At present we are doing Payroll Project .I would like to set some special keys for my forms and i want the coding to do the same .Pls Provide me source code for setting keys as soon as possible
Generate Keys
Generate Keys  hello i need code to generate key , after that send Keys to email address user. for example if you member in your website,if member not having Secret Keys not can download files if member having secret key i
Isolation level is used by the DBMS.
Isolation level is used by the DBMS.  What isolation level is used by the DBMS when inserting, updating and selecting rows from a database
Advanced DBMS questions
Advanced DBMS questions   Five company/organization that involves in SQL Server database migration. what is the Transaction Recovery Method. What does Cloud Computing contributes in the RDBMS? Importance
the isolation levels supported by my DBMS
the isolation levels supported by my DBMS  How can I determine the isolation levels supported by my DBMS
Error is: Generated keys not requested.
Error is: Generated keys not requested.   Hi, Following error is coming in my program. Error is: Generated keys not requested. You need to specify... = conn.prepareStatement(queryInsert,Statement.RETURN_GENERATED_KEYS); Thanks
Detecting Duplicate Keys
Detecting Duplicate Keys  Detecting Duplicate Keys I have a program that inserts rows in a table. My table has a column 'Name' that has a unique constraint. If the user attempts to insert a duplicate name into the table, I want
Ask DBMS Questions online
Ask DBMS Questions online       DBMS stands for Data Base Management System (DBMS) is a set of computer programs that controls the creation, organization
Version of com.datomic>s3-access-keys dependency
List of Version of com.datomic>s3-access-keys dependency
Version of com.noodlesandwich>rekord-keys dependency
List of Version of com.noodlesandwich>rekord-keys dependency
Version of com.noodlesandwich>rekord-keys dependency
List of Version of com.noodlesandwich>rekord-keys dependency
dbms_change_notification new_reg_start
dbms_change_notification new_reg_start  Please explain it "dbmschangenotification newregstart" Thanks in advance
PHP list array keys
array_keys() function returns the keys of the the given array. It returns the keys in the form of array. Example of PHP list Array Keys <?php...;   $key=array_keys($ar1);     print_r($key); ?>
how to create customise shortcut keys in jsp?
how to create customise shortcut keys in jsp?  I want to use shortcut keys in my application. keys like' EX: 1)S-Slag 2)ex-Exposure etc
Get information about foreign keys used in a table.
Get information about foreign keys used in a table.  How can I get information about foreign keys used in a table
Maven Dependency s3-access-keys >> 0.1.4
You should include the dependency code given in this page to add Maven Dependency of com.datomic >> s3-access-keys version0.1.4 in your project
Maven Dependency s3-access-keys >> 0.1.6
You should include the dependency code given in this page to add Maven Dependency of com.datomic >> s3-access-keys version0.1.6 in your project
Maven Dependency rekord-keys >> 0.3
You should include the dependency code given in this page to add Maven Dependency of com.noodlesandwich >> rekord-keys version0.3 in your project
get information about foreign keys - JDBC
get information about foreign keys  How to get the information about foreign keys in Java

Ads

 
Advertisement null

Ads