Entity integrity constraint - relational constraints, Database Management System

It defines that no primary key value can be null. This is as the primary key is used to recognize individual tuple in the relation. So we will not be able to recognize the records uniquely containing null values for the primary key attributes. This constraint is specified on single individual relation.

 Example: Let R be the Table

A#

B

C

Null

B1

C1

A2

B2

C2

Null

B3

C3

A4

B4

C3

A5

B1

C5

Note:

1) '#' shows the Primary key of a relation.

In the relation R above, the primary key has null values in the tuples t1 & t3. NULL value in primary key is not allowed, therefore, relation instance is an invalid instance.

Posted Date: 3/6/2013 5:31:24 AM | Location : United States







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

Write discussion on Entity integrity constraint - relational constraints
Your posts are moderated
Related Questions
In which format database schema is written ? Data base schema is written in the DDL format.

Can your organization scan large format documents? Yes, large format scanning used for such entities as city plans and blueprints is available. We selected scanners with the ab

Why is need for the multiple access paths?

Define tuple variable? Tuple variables are used for comparing two tuples in the same relation. The tuple variables are explained in the from clause by way of the as clause.

Problem: (a) Data mining is one of the best ways to analyse data and using software techniques, hidden and unexpected patterns and relationships in sets of data can be extrac

Explain the Exec statement in SQL Ans: Exec statement has the structure    EXEC SQL END-EXEC   Embeded SQl statements are of a form identical to non embedded SQL statem

What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row

What is a data dictionary? Data Dictionary is a main source of data in a data management system.  Its major function is to carry the creation and management of data definition

What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and

Which is a legal expression in SQL? SELECT NAME FROM EMPLOYEE is a legal expression in SQL.