Entity Vs Referential Integrity in RDBMS

Entity means independent and referential means dependent. These two integrities play key role.

According to computerworld RDBMS is not suitable for current day massive volume of data. So you need other kind of databases .

Those are called NoSQL – Not only SQL database. But, still you need to be master in SQL. If you want to master in SQL you can try this course.

Entity Vs Referential Integrity.

Entity Integrity.

  • No attribute participating in the primary key of a base relation is allowed to contain any nulls.
  • Primary key performs the unique identification function in relational model
  • Thus a null primary key value within a base relation would be like saying that there was some entity that had no known identity
  • An entity that cannot be identified is a contradiction in terms, hence the name entity integrity

Referential integrity.

  • If a base relation(Table) R2 includes a foreign key FK matching the primary key PK of some base relation R1, then every value of FK in R2 must either be equal to the value of PK in some tuple of R1 or be wholly null.
  • A given foreign key value must have matching primary key value in some tuple of the referenced relation if that foreign key value is non null.
  • Sometimes it is necessary to permit foreign keys to accept nulls.
  • Here, it must be noted that the null are of ‘value does not exist’ rather than ‘value unknown’ variety.

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.