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
In which database can extended stored procedures be added?
explain detail about ftp in datastage?
Explain about relational database management systems?
How to use timestamp datatypes
How to combine two function together?
What is a database development?
What is data modeling with example?
Explain the process of the user request and data generating?
Explain about the storage and physical database design?
How to use online Backups?
How to replace not in with not exist?
Can an extended stored procedure be called from inside a user-defined function?
What is database design and development?
Explain about post-relational databases?
What is the database development process?