Before defines the second type of integrity constraint, viz., Entity Integrity, we should be well-known with the concept of NULL.

Mostly, NULL is intended as a basis for dealing with the trouble of missing information. This type of situation is frequently encountered in the actual world. For instance, historical records sometimes have entries such as "Date of birth unknown", or police records may contain the entry "Present whereabouts unknown." Therefore it is necessary to have some way of dealing with such concepts in database systems.

Therefore Codd proposed an approach to this issue that creates use of special markers known as NULL to show such missing information.

A given attribute in the relation may or may not be allowed to include NULL. However, can the Primary key or any of its components (in case of the primary key is a composite key) contain a NULL? To answer this Query an Entity Integrity Rule states: No component of the primary key of a relation is permitted to accept NULL. In different words, the definition of each attribute involved in the primary key of any basic relation have to explicitly or implicitly contain the specifications of NULL NOT ALLOWED.

Posted Date: 3/6/2013 6:40:06 AM | Location : United States

Ask an Expert

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

Write discussion on Entity integrity
Your posts are moderated

Write your message here..

Related Questions

gaps in sequence values can happen when-sequences, Gaps in sequence values... Gaps in sequence values can happen when: -     A rollback happens that is when a statement changes are not accepted. -     When the system crashes -     When a sequence i

What do you mean by correlated subquery, What do you mean by Correlated sub... What do you mean by Correlated subquery? Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is writ

Mention the purpose of sid and sod lines, Mention the purpose of SID and SO... Mention the purpose of SID and SOD lines SID (Serial input data line): It is an input line by which the microprocessor accepts serial data. SOD (Serial output data line)

What is a recovery scheme, What is a recovery scheme? An integral part ... What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.

Stock market, need requirement analysis for database management of stock ma... need requirement analysis for database management of stock market

What way a particular application views data from database, What is the way... What is the way a particular application views the data from the database that the application uses? Sub schema is the way a particular application views the data from the data

Sorting-stacks, 1. Identify the comparisons and exchanges made to sort the ... 1. Identify the comparisons and exchanges made to sort the following array using the selection exchange sort technique. Note: you may not need all columns. Ori

Keys, #questiontypes of keys examples.. #questiontypes of keys examples..

Lack of redundancy, Lack of Redundancy We have talked about the problems o... Lack of Redundancy We have talked about the problems of repetition of information in a database. Such repetition should be stay away as much as possible. Let us state once again t

Candidate keys, Super keys of a relation can have extra attributes. Candida... Super keys of a relation can have extra attributes. Candidate keys are minimal super key, i.e. such a key have no extraneous attribute. An attribute is known as extraneous if even