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
Discuss the problem of Spurious tuples and how we may prevent it.    Ans:  A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad

Let us first look into some of the important features of ER model. Entity relationship model is a high-level conceptual data model. It permits us to define the data invo

Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro

Define rotational latency time. The time spent waiting for the sector to be accessed to appear under the head is known as the rotational latency time.

Explain the two constraints, check and foreign key in SQL along with an example for each. Give the syntax. CHECK constraint - CHECK constraint specifies an expression which

Question: a) What is Client/Server and what benefits can be expected from Client/Server systems? b) Explain what middleware is and what it does. Why would MIS managers be p

What is recovery management component? Ensuring durability is the responsibility of a software component of the base system known as the recovery management component.

Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among

Project Description: I need a point of sale for motels. It needs to run on windows and requires being network able so that we can have more than one computer using it at once.

I have a homework assignment due today by midnight. I need help understanding databasse normalization and determining the type of form violation & how to fix the violation.