Describe entity referential integrity and integrity, Database Management System

Assignment Help:

Describe entity referential integrity and integrity. Give an example of each.

Entity Integrity Rule - If there is a attribute A of relation R is a prime attribute of R then A cannot accept null values.

Referential Integrity Rule - In referential integrity, it is ensured in which a value in which appears in one association for a given set of attributes also appears for a certain set of attributes in another relation.

For example:

286_Student details.png

Roll No is the primary key within the relation STUDENT and Roll No + Course is the primary key of the relation GRADE. (Entity Integrity)
Roll No in the relation GRADE (child table) is a foreign key, which is referenced from the relation STUDENT (parent table). (Referential Integrity).


Related Discussions:- Describe entity referential integrity and integrity

ERD, online eductional management system ke diagram

online eductional management system ke diagram

Explain the term high level dml, Explain the term High level DML? High...

Explain the term High level DML? High level DML A high-level or non-procedural DML permit the user to specify what data is needed without specifying how it is to be acquired.

Define the concept of object diagram, Define the concept of Object Diagram ...

Define the concept of Object Diagram An object diagram shows a set of the objects and their relationships with each other at a point of time. In a static view, object diagram

Views-data control, Views A view is like a window by which data from ta...

Views A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT stat

What are the dbms languages, What are the DBMS languages? Explain.  Ans...

What are the DBMS languages? Explain.  Ans: a) Data Definition Languages (DDL): It is employed to specify database schema for example CREATE DROP statements etc.     b)  Dat

Database for online assignment system, i want to database for online assign...

i want to database for online assignment submission system

What is object oriented model, What is Object Oriented model? This mod...

What is Object Oriented model? This model is based on collection of objects. An object has values stored in instance variables with in the object. An object also having bodies

What is first normal form, What is first normal form? The domain of att...

What is first normal form? The domain of attribute must contain only atomic (simple, indivisible) values.

Data Minnning, Can i get help with weka software

Can i get help with weka software

Authorisation, Authorisation Authorisation is the culmination of the ad...

Authorisation Authorisation is the culmination of the administrative policies of the organisation.  As the name shows, authorisation is a set of rules that can be used to verif

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd