Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

In which database can extended stored procedures be added?

864


explain detail about ftp in datastage?

2190


Explain about relational database management systems?

923


How to use timestamp datatypes

1976


How to combine two function together?

2073


What is a database development?

912


What is data modeling with example?

917


Explain the process of the user request and data generating?

1046


Explain about the storage and physical database design?

871


How to use online Backups?

2158


How to replace not in with not exist?

1997


Can an extended stored procedure be called from inside a user-defined function?

1013


What is database design and development?

958


Explain about post-relational databases?

960


What is the database development process?

1161