0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Why do you designate one of the candidate key of relation to be the primary key?
We designate one of the candidate key of a relation to be a primary key because that primary key is use for any foreign key references.
Non-prime attribute in DBMS?
Prime attribute are part of any candidate key. Non-prime attribute are not part of any candidate key.
What is meant by the determinant of a math equation?
A single math equation does not have a determinant. A system of equations (3x3 , 4x4, etc.) will have a determinant. You can find a determinant of a system by converting the system into a corresponding matrix and finding its determinant.
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.
Do all matrices have determinant?
Only square matrices have a determinant
What is bcnf explain with respect to dbms?
Boyce -Codd normal form which is one of the forms of dbms noramlizations.normalization is converting the relations or tables in a standard form.bcnf is based on functional dependencies that take into account all candidate keys.a relation is in bcnf if every determinant has a candidate key..:)
What is candidate key in dbms?
more than one primary key to identify the record uniquely is called candidate key.
Candidate key and primary key differnece?
All Primary keys are definitely Candidate Keys. A Candidate key is one which can be used as a Primary key that is not null and unique. That is one of the candidate keys can be chosen as a primary key.A Candidate key is a Unique Key and it can be used to find out any particular Tuple (row) in a table. The following are the differences between A Candidate key and a Primary Key: 1) A Unique key can be null but not a Primary key 2) On a table we can have only 1 primary key but 'N' number of unique keys.
What is the difference between primary key and candidate key?
Candidate Key is used to uniquely identify the records of a table. An attribute becomes a Primary Key, if all the other candidate keys lose race for being qualified as Primary Key.
What is the primary determinant of elasticity of supply?
A key determinant of the price elasticity pf supply is the availability of alternative products. The more choices consumers have, the more elasticity the price must have.
Why do you designate one of the candidate key of relation to be the primary key?
We designate one of the candidate key of a relation to be a primary key because that primary key is use for any foreign key references.
What are the determinant of social stratification?
The key determinants of social stratification are economic, social and political policies.
How do you find candidate key in a relation?
have sex
Determinant of adjoint a is given find determinant of a?
relationship between determinant and adjoint
Non-prime attribute in DBMS?
Prime attribute are part of any candidate key. Non-prime attribute are not part of any candidate key.
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 is meant by the determinant of a math equation?
A single math equation does not have a determinant. A system of equations (3x3 , 4x4, etc.) will have a determinant. You can find a determinant of a system by converting the system into a corresponding matrix and finding its determinant.
