Explain about primary key, Database Management System

Explain about primary key

Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate keys in the STUDENT table, the college would clearly use Roll as the primary key of the table.

 

Posted Date: 7/26/2013 6:11:11 AM | Location : United States







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

Write discussion on Explain about primary key
Your posts are moderated
Related Questions
explain in detail about time stamp orderting/

State the terms Designing the database and Normalization Designing the database: Out of the ERD we have formed, it is very easy to verify the tables, the attributes which the

Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

how many hourse have been spent on a certain project

(1)     Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

properties of derirable decomposition

List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im

Define object-relational systems? Systems that give object-oriented extensions to relational systems are known as object-relational systems.

The Proliferation of Object-Oriented Methods The first few years of the 1990s saw blossoming of around fifty various object oriented methods. This proliferation is a sign of g

To eliminate duplicate rows (distinct operator)  Example: SELECT DISTINCT DEPTNO FROM EMP;