answersLogoWhite

0

A primary Key which uniquely identifies a row of table,primary key does not allow null values and also not allow duplicate values.

Superkey is defined in the relational model of database organization as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. Equivalently a superkey can also be defined as a set of attributes of a relvar upon which all attributes of the relvar are functionally dependent. If you more information so you can visit this website:http://www.iyogibusiness.com

User Avatar

Wiki User

15y ago

Still curious? Ask our experts.

Chat with our AI personalities

JudyJudy
Simplicity is my specialty.
Chat with Judy
RafaRafa
There's no fun in playing it safe. Why not try something a little unhinged?
Chat with Rafa
JordanJordan
Looking for a career mentor? I've seen my fair share of shake-ups.
Chat with Jordan
More answers

Different set of attributes which are able to identify any row in the database is known as super key. And minimal super key is termed as candidate key i.e. among set of super keys one with minimum number of attributes. Primary key could be any key which is able to identify a specific row in database in a unique manner.

User Avatar

Wiki User

16y ago
User Avatar

primary key. is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key while

A composite key is a primary key that consists of more than one column.Oracle will create a composite primary key index on the table to implement and enforce the composite key. Composite keys are also known as concatenated or aggregate keys.

ExampleFor example, the LINE_ITEMS table may have a composite key on {order_ID, item_Number}: CREATE TABLE line_items ( order_ID NUMBER, item_Number NUMBER, product_Id NUMBER, quantity NUMBER, PRIMARY KEY (order_ID, item_Number));
User Avatar

Wiki User

12y ago
User Avatar

Add your answer:

Earn +20 pts
Q: Difference between primary key candidate key and super key?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Engineering

Primary and secondary key in DBMS?

key is nothing but a attribute and attribute is the aspect of a member in an entity entity is represented by set of attributes. primary key is the one which is selected by the database designer to identify a entity in a entity set super key is one or more attributes which is used to identify the entity in an entity set uniquely candidate key minimal number of super keys... in some context super key and secondary key are equal. foreign key is the relational constraint between tables or entities A secondary key is made on a field that you would like to be indexed for faster searches! For any Further detail,you visit this website:http://www.iyogibusiness.com


Difference between super and final keyword?

this is a reference to the current classsuper is a reference to the super class of the current class (the class from which this class extends). You can use super.super if you want to access the second level class. (The class your parent class extends) The purpose of having thisand super keywords is to differentiate between methods and variables in classes that may have the same name as that in the parent class. Under such situations if we want to ensure that only the methods from a particular class only gets called we can use this and super.


What is the difference between overloading and overriding methods in object?

Here are some of the most common differences between both of them. If you are working in Java for more than 1 year, you might be familiar with all of them but any way its good revision: 1) First and major difference between Overloading and Overriding is that former occur during compile time while later occur during runtime. 2) Second difference between Overloading and Overriding is that, you can overload method in same class but you can only override method in sub class. 3) Third difference is that you can overload static method in Java but you can not override static method in Java. In fact when you declare same method in Sub Class it's known as method hiding because it hide super class method instead of overriding it. 4) Overloaded methods are bonded using static binding and Type of reference variable is used, while Overridden method are bonded using dynamic bonding based upon actual Object. 5) Rules of Overloading and Overriding is different in Java. In order to overload a method you need to change its method signature but that is not required for overriding any method in Java.


What is hydraulics in a simple answer?

Hydraulics..... or moving of the car super super simple.


What is mean by Blowing factor in steam blowing?

Disturbance Or Correction or K Factor in steam blowing in Power Plants is the ratio of Drag created during steam blowing to the drag occurring during Maximum Continuous Rating. Equation of disturbance factor K is shown as below: K=ΔP1/ΔP2 ΔP1=PD1-PS1;ΔP2=PD2-PS2 ΔP1:Difference pressure of steam drum and corresponding super heater during steam blowing-out. ΔP2: Difference pressure of steam drum and corresponding super heater in normal operation of boiler