What is Alternate Key

Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, they can still recognize a row.

 

Posted Date: 7/26/2013 6:11:55 AM | Location : United States

Ask an Expert

Related Discussions:- What is alternate key, Assignment Help, Ask Question on What is alternate key, Get Answer, Expert's Help, What is alternate key Discussions

Write discussion on What is alternate key
Your posts are moderated

Write your message here..

Related Questions

Explain the outer join, Define Outer join Outer join - If there are any... Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected

Information system fundamentals, A full discription of the new, a discripti... A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

Data mining, 1.Why we need data mining? Give an example to illustrate your ... 1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

Write the motivations led to development of oo-dbms, Write the motivations ... Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

Create database for car application, The Database MySQL scripts cars_f... The Database MySQL scripts cars_for_sale.sql and car_details.sql containing the data to use for this task have been supplied. To complete this task, you need to first create

Difference among a primary index and a secondary index, What is the differe... What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.

Dataware house, multidimensional data model multidimensional data model

What is a built-in, What is a Built-in A notation of identity is built-... What is a Built-in A notation of identity is built-into the data model or programming language and no user-supplied identifier is needed. This form of identity is used in objec

What is nested queries explain in details, What is Nested Queries explain i... What is Nested Queries explain in details? Nested Queries - A SELECT query could have subquery(s) in it. While a SELECT query having another SELECT query in it, is known as n

How many types of users works on database, How many types of users works on... How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with