Key constraint - relational constraints, Database Management System

This constraint shows that the key attribute value in each tuple must be unique, i.e., no two tuples have the similar value for the key attribute. This is because the value of the primary key is used to recognize the tuples in the relation.

 

Example: If A is the key attribute in the following relation R than A1, A2 and A3 must be unique.

 

A

 

B

 

A1

 

B1

 

A3

 

B2

 

A2

 

B2

 

Example: In relation PERSON, PERSON_ID is primary key so PERSON_ID cannot be given as the similar for two persons.

Integrity Constraint

There are two kinds of integrity constraints:

  • Entity Integrity Constraint
  • Referential Integrity Constraint
Posted Date: 3/6/2013 5:30:34 AM | Location : United States







Related Discussions:- Key constraint - relational constraints, Assignment Help, Ask Question on Key constraint - relational constraints, Get Answer, Expert's Help, Key constraint - relational constraints Discussions

Write discussion on Key constraint - relational constraints
Your posts are moderated
Related Questions
What is trigger?  Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.

What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

What is called query processing? Query processing refers to the range of activities included in extracting data from a database.

What is self-transition? If there is a transition which goes back to same state, it is known as "self- transition." With a trigger action exit action would be executed f

Explain Candidate key? Candidate Key - A candidate key is a minimal superkey, that can be used to uniquely identify a tuple in the relation.

Can we delete data element, which is being used by table fields. No we cant delete data element.

Draw the database using the ER approach and then make the tables accordingly. Populate the tables so that every table have at least 10 tuples. Then using Java and SQL, execute the

Draw an entity relationship diagram (ERD) for the following situation: A company has a number of employees. Each employee is identified by an Employee_Id. The company wants to st

What is Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.

Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA