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
1. Define and discuss Work Breakdown Structure, Critical Path Analysis, PERT charts and GANTT charts. Describe the role of each in determining scope, budgets, and schedules? What

create an e-r diagram usuing graphical dipicted software that could theoritically be used in resturant application

What are the responsibility of File manager? File Manager : Manager allocation of space on disk storage and the data structures used to represent within stored on disk. It is a

What is meant by heuristic optimisation?  Discuss the main heuristics that are applied during query optimisation.  Ans:  In heuristic optimization, heuristics are employed to r

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

Boyce-Code Normal Form (BCNF) A relationship is said to be in BCNF if it is already in 3NF and the left hand side of each dependency is a candidate key. A relation who is in 3N

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

3. (10 points) Assume that you have been presented with the following relation for the Baxter Aviation database: Charters (Pilot#, Pilot name, Aircraft ID#, #seats, Village, Fligh

How can Redundant Associations be done It can be done by asking questions: i)  Is there a specific arrangement of network which would optimize critical aspects of completed

Which language has presently become the defacto standard for interfacing application programs along with relational database system? The language which has recently become the