answersLogoWhite

0


Best Answer
Primary key:------------Definition: The primary key of a relational table uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number in a table with no more than one record per person) or it can be generated by the DBMS (such as a globally unique identifier, or GUID, in Microsoft SQL Server). Primary keys may consist of a single attribute or multiple attributes in combination.

Examples:

Imagine we have a STUDENTS table that contains a record for each student at a university. The student's unique student ID number would be a good choice for a primary key in the STUDENTS table. The student's first and last name would not be a good choice, as there is always the chance that more than one student might have the same name.

Candidate key:-----

Definition: A candidate key is a combination of attributes that can be uniquely used to identify a database record without any extraneous data. Each table may have one or more candidate keys. One of these candidate keys is selected as the table primary key.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Give some example for primary key unique key and candidate key?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Give two reasons why primary victories are important to candidates?

There are two reasons why primary victories are important to candidates. They indicate the strength of the candidate and provide information on the type of voters who are voting for the candidate.


What determines how a candidate is chosen when no candidate wins a majority vote in a primary election?

The answer depends on the party and the state. Some states have a non-binding primary, some states apportion their delegation according to the primary percentages and some states give all of their votes to the candidate who wins a plurality in the primary. Some parties have some "super delegates" who decide for themselves how to vote.


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.


Explain and give an example of a primary industry?

A primary industry is one involved in the extraction of resources from their natural setting. An example of such is the mining industry.


Can you give me an example of libel as a sentence?

A newspaper prints a false statement about a candidate involved in a local election (that he didn't pay his taxes). The candidate loses the election. <33


Can you give an example of an opening remarks?

Example would be Martin Luther Kings "I Have a Dream". The opening should be unique to the person


What are Open Primary elections?

From: http://en.wikipedia.org/wiki/Primary_elections#TypesOpen. A registered voter may vote in any party primary regardless of his own party affiliation. When voters do not register with a party before the primary, it is called a pick-a-party primary because the voter can select which party's primary he or she wishes to vote in on election day. Because of the open nature of this system, a practice known as "raiding" may occur. "Raiding" consists of voters of one party crossing over and voting in the primary of another party, effectively allowing a party to help choose its opposition's candidate. The theory is that opposing party members vote for the weakest candidate of the opposite party in order to give their own party the advantage in the general election. An example of this can be seen in the 1998 Vermont senatorial primary with the election of Fred Tuttle for the Republican candidate.


Explain the difference between primary data and secondary data give an example of each?

Primary data is data collected firsthand, through surveys, interviews, experiments, etc. by the researcher, while secondary data is existing data that has already been collected by someone else. An example of primary data would be survey responses collected by a marketing team for a new product. An example of secondary data would be industry reports or census data obtained from a government website.


Can a candidate who has left the race give his delegates to any other candidate he wants?

No, he cannot. He can endorse or give his support to another candidate, which his delegates usually always give their votes to.


Can you please give me an example of opening remarks?

Example would be Martin Luther Kings "I have a dream". The opening should be unique to the person


Can you give me a sentence of the words candidate?

He was the Republican candidate for President.


Give example of primary secondary cells?

A primary cell can't be recharged, for example am ordinary 'D' cell, while secondary cells are rechargeable, e.g. one of the cells in a car battery.