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
how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

You are to write a property management database program that allows a real estate agent to view, add, search, and save property listings. The program is to do the following: 1.


What are the three fundamental operations that are regular to MySQL Programs? a) Establishing a connection to the MySQL server b) Choosing a database. c) Disconnecting fr

What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be

Explain the Dynamic Hashing Techniques There are two methods in it: extendible hashing - stores an access structure in addition to the file, and therefore is somewhat identica

How external/conceptual mapping and conceptual /internal mapping is performed

A database is to be constructed to remain track of the teams and games of a sport league. A team has a number of players, not all of whom participate in every game. It is desired

Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person.   Derived  Attributes that are not stored directly but can be derived

List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti