What is alternate key, Database Management System

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







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
Related Questions
Prepare a data flow diagram for computing the volume and surface area of a cylinder. Inputs are the height and radius of the cylinder. Outputs are the volume and surface area of th

Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca

How does a query tree represent a relational algebra expression?      Ans: This includes transforming an initial expression (tree) into an equivalent expression (tree) that is

What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in

MySQL Database Merge Project Description: I have two databases, I need merge the data of one database into another Work to be done online right now. Payment can be done

If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

Greater potential for bugs: Since the sites of a distributed system operate simultaneously, it is more complex to ensure the correctness of algorithms. The art of constructing dis

What is a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the significant characteristics of a regular database. Dataset