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
What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a

Consider the following relational database: STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course#, sem

Multiple-mode locks : It offers two locks: exclusive locks and shared locks. But why do we require these two locks? There are a lot of transactions in the database system that neve

What is conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.

Which database level is closest to the users? External database level is closest to the users.


Which operation is used if we are interested in only certain columns of a table? PROJECTION operation is used if we are interested in only certain columns of a table.

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen

Define tuple variable Tuple variable is a type of variable whose domain is the set of all tuples.