Define candidate key, alternate key, composite key?
Answer Posted / mona
A set of fields that uniquely identifies a tuple according
to a key constraint is called candidate key for the relation.
(1)No two values of keys are same
(2)the set of fields{sid,sname} is not a key for
students,because this set properly contains the key{sid}.
The set {sid,sname} is an example of a super key,which is a
set of fields that contains a key.
EX:
create table customer(customer_name char(20),street
char(30),city char(30),primary key(customer_name));
Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Write the fastest query to find out how many rows exist in a table?
How can you fix a poorly performing query?
fact table and dimension table containg one to many relationship or many to one relastionship
Can an extended stored procedure be called from inside a user-defined function?
Explain about normal forms?
Why does this query return 0?
What is database design and development?
How is data stored in dbms?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What is the database development process?
How can I detect whether a given connection is blocked?
Which four data types cannot be used as a return type from a user-defined function?
Explain about query and reporting.
What is an application role and explain a scenario when you would use one?
What is dbms and its application?