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
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? A hash index organizes the search keys, with their associated pointers, into a hash file structure.

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

WHAT IS DSS? WRITE ITS REQUIREMENTS.

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 for the following data. This table is part of the OHSU database of extracurricular activities and tracks the DMICE band's co

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?  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 Other System Design Issue How to realise subsystems; through hardware or software? How is object model mapped on chosen hardware software? Mapping

Question 1 Explain the functions of the following Storage Manager Buffer Manager Transaction Manager 2 Discuss about system catalog in a relational DBMS 3