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
I need to Map an E-R diagram to a relational schema

sir, could anybody help me in getting complete information about the mentioned topic

Project Description: I need a point of sale for motels. It needs to run on windows and requires being network able so that we can have more than one computer using it at once.

Describe integrity constraints? Integrity Constraints - A database is just as excellent as the information stored in it, and a DBMS must therefore help avoid the entry of inc

Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

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

Explain the shadow paging recovery technique.  Ans: Shadow paging is a method used to acquire atomic and durable transactions, and provides the capability to manipulate pages i


What are the two types of errors? The two types of errors are: a) Logical error b) System error

Define the concept of Object Diagram An object diagram shows a set of the objects and their relationships with each other at a point of time. In a static view, object diagram