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
List any eight applications of DBMS. a) Universities b) Airlines c) Banking d) Credit card transactions e) Tele communication f) Sales g)Finance h) Manufac

Indexed (Indexed Sequential) File Organisation It organises the file like a big dictionary, i.e., records are kept in order of the key but an index is stored which also allows

What is Index? An index is a physical structure having pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possibl


Data Scrubbing 70,000 records Project Description: We need services of a developer competent in data cleansing/Data scrubbing. Scope: - 70,000 records in CSV format.

With the linear commit protocol, sites are connected in a chain, and the subtransaction at the left-hand end of the chain initiates the protocol. Propose a crash recovery protocol

Emergence of Client Server Architecture Some of the pioneering work that was completed by some of the relational database vendors permitted the computing to be distributed on m

What is the full form of DDL? DDL is stand for Data Definition Language.

Consider a systems development project with the following data Activity                                Duration (weeks)        Precedence Relationship 1. Software design

The ER diagram clearly showing the additional tables you have implemented. SQL table creation scripts for the tables you have set up. SQL scripts showing the sample data you