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 operation of the data warehouse, Using a labelled diagram expla... Using a labelled diagram explain the operation of the Data Warehouse, define the basic architectural components and outline the main functionalities. Briefly explain the role an op

What is a hash index, What is a hash index? A hash index organizes the ... What is a hash index? A hash index organizes the search keys, with their associated pointers, into a hash file structure.

Oracle, Extend your CREATE TABLE statement from problem 3 with referential ... Extend your CREATE TABLE statement from problem 3 with referential integrity constraints. Updates and deletes on related rows are restricted. 6. From examination of the sample data

DSS, WHAT IS DSS? WRITE ITS REQUIREMENTS. WHAT IS DSS? WRITE ITS REQUIREMENTS.

What is known as sequential file organization, What is known as sequential ... What is known as sequential file organization? In the sequential file organization, the records are kept in sequential order, according to the value of a "search key" of every

Determine the minimal set of functional dependencies, Determine the minimal... Determine the minimal set of functional dependencies for the following data. This table is part of the OHSU database of extracurricular activities and tracks the DMICE band's co

Mixed fragmentation, Mixed fragmentation: Sometimes, horizontal fragmentati... Mixed fragmentation: Sometimes, horizontal fragmentation or vertical fragmentation of a database schema by itself is insufficient to sufficiently distribute the data for some appli

Define instance and schema, Define instance and schema?  Instance:  C... Define instance and schema?  Instance:  Collection of  data  kept in the  data  base  at  a  particular  moment  is  known as an Instance of the database.  Schema: The o

Determine the subsystem design issue, Determine the Other System Design Iss... Determine the Other System Design Issue How to realise subsystems; through hardware or software? How is object model mapped on chosen hardware software? Mapping

Explain embedding sql statements, Question 1 Explain the functions of t... Question 1 Explain the functions of the following Storage Manager Buffer Manager Transaction Manager 2 Discuss about system catalog in a relational DBMS 3