Candidate key, DOT NET Programming

What is a candidate key?

A table may have more than one combination of columns that could uniquely identify the rows in a table; every combination is a candidate key. During the database design you can pick up one of the candidate keys to be the primary key. For e.g., in the supplier table the supplierid and the suppliername can be a candidate key but you will only pick up the supplierid as the primary key.

Posted Date: 9/24/2012 4:33:29 AM | Location : United States







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

Write discussion on Candidate key
Your posts are moderated
Related Questions
What is cyclomatic complexity and why is it important? Cyclomatic complexity is a computer science metric (measurement) developed by Thomas McCabe used to generally calculate t

What are methods? Methods are the building blocks of a class, in which they are linked together to share and process data to produce the result. In other words, a method is a b

Web Developer Project Description: We are in need of an expert web developer for long term connection; please apply with samples if you have the subsequent skills: ASP.NET

What is DMAIC and DMADV? The Six Sigma has two key methodologies viz. DMAIC and DMADV. The DMAIC is used to improve an existing business process. While DMADV is used to create

What is the use of DataView? User-defined view of a table is contained in a DataView. A complete table or a small section of table depending on some criteria can be shown by an

Show the code for the file dependency in cache? Partial Class Default_aspx Public Sub displayAnnouncement() Dim announcement As String If Cache("announcement") Is Noth

How can you provide an alternating color scheme in a Repeater control?  AlternatingItemTemplate Like the ItemTemplate element, but rendered for each other row (alternating item

Explain MVC and how it is diffrennt from Asp.net

What is object-oriented programming (OOP)? OOP is a method to develop logical modules, such as classes that contain properties, methods, fields, and events. An object is formed

What is XML DOM? The DOM stands for Document Object Model, which explains the logical formation of documents and provides the way to access and manipulate a document. It suppli