answersLogoWhite

0


Want this question answered?

Be notified when an answer is posted

Add your answer:

Earn +20 pts
Q: What is a super key in DBMS?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the prime attribute in DBMS?

prime attributes are the attributes of a candidate key which will give uniqueness. a candidate key is (the subset of superkey) which gives uniqueness. Super key is the maximum set of attributes that can provide uniqueness example ABCDE is a super key AB CD DE are the candidate keys s.t. AB is the primary key. CD and DE are the secondary/alternate keys.


What ensures the value of the foreign key matches another tables primary key?

It is the DBMS that ensures the value of the foreign key matches another table's primary key when referential integrity constraints are enabled within the DBMS


How many super keys are possible in DBMS having m attributes?

In dbms with m attributes 2^m-1 keys are possible. BY-ROHIT


What is secondary indexes in dbms?

secondary index is a key which is created other than primary key, to speed up processing.


Could DBMS being the key for the billionaires of the future?

k onda k onda


Definition of key in dbms?

It is a pool of data through which data are enter into into the table for data management.


Why relation have key in DBMS?

A software system that facilitates the creation and maintenance and use of an electronic database


What are the types of dbms attributes?

Types of Attributes in Dbms areKey or non key attributesRequired or optional AttributesSimple or composite AttributesSingle-valued and multi-valued AttributesStored, Coded or derived Attributes


Non-prime attribute in DBMS?

Prime attribute are part of any candidate key. Non-prime attribute are not part of any candidate key.


Can super key be as primary key?

I think super key is treated as the primary key because in a table their will be only one primary key.


What are highlights of DBMS?

NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS


Difference between super key and composite key?

A Super key and composite key are similar to one another. Both of them are used to uniquely identify a row in a database table. A super key is a set of columns within a table that can be used to identify a particular row in a table. A super key can be only one column or a combination of multiple columns. If a super key contains multiple columns it becomes a composite key.