StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

What are referential integrity constraints Provide an example - Admission/Application Essay Example

Cite this document
Summary
When one database table comprises a FK (foreign key) to any other table, the idea of referential integrity outlines that we cannot insert a record to the…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER93.8% of users find it useful
What are referential integrity constraints Provide an example
Read Text Preview

Extract of sample "What are referential integrity constraints Provide an example"

ID # What are “referential integrity constraints”? Provide an example Referential integrity is an important feature of databases that ensures consistent associations among database tables. When one database table comprises a FK (foreign key) to any other table, the idea of referential integrity outlines that we cannot insert a record to the database table that holds the foreign key unless there is an equivalent record in the associated table. Additionally, it also comprises methods for example cascading delete and cascading update; to make sure transformations are formulated to the associated tables are revealed in the primary table (Chapple) and (Microsoft).

In addition, referential integrity offers techniques to deal with relationships among tables. In this scenario, when we make a table, we can describe constraints to make sure that the data inserted into a specific column has corresponding values in another table. However, there are three kinds of references which can be described in a table: references from another table, references to another table and self-references, that is, references inside the similar table (Sybase).Moreover, the referential integrity can be explained with a lot of examples: for instance, suppose Table B has a FK that points to a (object) field in a Table A.

In this scenario, referential integrity would avoid us from inserting a record to Table B that is not associated with Table A. In addition, referential integrity systems identifies that whenever we delete a record from Table A, some database records in Table B that are associated to the deleted record should also be deleted from the table. This situation is known as cascading delete. Lastly, the referential integrity policy could identify that whenever we change the value of a associated field in Table A, the entire database records in Table B that are associated to it will as well be customized consequently.

This is known as the cascading update (Webopedia).Works CitedChapple, Mike. Referential Integrity. 2011. 19 September 2011 .Microsoft. referential integrity constraint (Entity Data Model). 2011. 20 September 2011 .Sybase. Specifying referential integrity constraints. 2011. 22 September 2011 .Webopedia. referential integrity. 2011. 22 September 2011 .

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“What are referential integrity constraints Provide an example Admission/Application Essay”, n.d.)
What are referential integrity constraints Provide an example Admission/Application Essay. Retrieved from https://studentshare.org/information-technology/1580338-what-are-referential-integrity-constraints-provide-an-example
(What Are Referential Integrity Constraints Provide an Example Admission/Application Essay)
What Are Referential Integrity Constraints Provide an Example Admission/Application Essay. https://studentshare.org/information-technology/1580338-what-are-referential-integrity-constraints-provide-an-example.
“What Are Referential Integrity Constraints Provide an Example Admission/Application Essay”, n.d. https://studentshare.org/information-technology/1580338-what-are-referential-integrity-constraints-provide-an-example.
  • Cited: 0 times

CHECK THESE SAMPLES OF What are referential integrity constraints Provide an example

The Design and Implementation of a Database Managed Website

This project "The Design and Implementation of a Database Managed Website" was initiated to develop a customised content management system for a case organisation's website which could provide timely, accurate and standardised information quickly on the website with proper database support at the back end to ensure that no information can be lost even if the web site is unavailable.... In addition, the database will also provide the capability to define various relationships among data that might be of some use to the organisation....
14 Pages (3500 words) Assignment

Software Development Life Cycle Models

A Standish Group research1 shows that not more than 9% of the software projects succeed in large companies.... Even out of this 9% projects, they hardly meet 42% of the originally planned requirements.... This astonishing revelation tells us that most of the software projects are either ill managed or have not been understood properly. … Owing to its importance, software life cycle models have always been of great interest to people who wanted to deliver software out of a production line....
9 Pages (2250 words) Essay

Relational Database Management System

For example, the S_DEPT table stores information about the departments of an organization. A Column is a collection of one type of data in a table.... For example, a column in the table S_DEPT specifies the names of the departments in the organization.... For example, the column containing department numbers in the S_DEPT table is created as a primary key and therefore every department number is different.... ? The process of deciding what the best collection of tables is for a given application is known as data-base modelling....
6 Pages (1500 words) Essay

Memo to Team Regarding Entity and Referential Integrity Constraints

The purpose of this memo is to emphasize the importance of the entity and referential integrity constraints in relation to the design/development of the University of Tong's New Student Class Registration System.... In this memo, you will find an overview of the concept of entity… Integrity constraints are applied in deign and development of database system to maintain the accuracy and integrity of data in the Colorado Technical Memo to Team Regarding Entity and referential integrity constraints Phase 2 Task Prof....
3 Pages (750 words) Essay

Intro to Rel Dbase Mgts Syst

Business rules are used for handling the referential integrity.... Using stored procedures for achieving the referential integrity does not involve the application development outside of data.... For example, a sales company's sales department stores the name of a salesman as Bill Brown while same name in personnel department is… Price of the product is shown as $45.... For example, a sales company's sales department stores the name of a salesman as Bill Brown while same name in personnel department is saved as William G brown, the probability of data inconsistency increases in similar cases....
2 Pages (500 words) Assignment

Data Base Administration

"Data Base Administration" paper states that database needs to understand challenges of technical and practical aspects database design and development along with administrative tasks.... Above tasks educates about creation of physical database and logical model based on E-R diagram.... hellip; Physical and logical data independence further makes maintenance of database and application-independent....
7 Pages (1750 words) Assignment

Sample Population

he research study will have data sources that will provide actual information shedding light on how employees can use the social media as a platform to raise grievances.... Additionally, the data source will be used to improve or emphasize on what the participants provide during the research.... In so doing, the information collected or data collected will be compared with what the information provided by the sample population and establish whether there is a relationship between the data....
8 Pages (2000 words) Assignment

Data, Technology, People, and Organizational Components of Information Systems

The paper "Data, Technology, People, and Organizational Components of Information Systems" will describe the functions of  such information systems: Management Information System, Knowledge management System, Customer Relationship Management system, and Supply chain management system.... hellip; An information system can be defined in terms of functional perspective or structural perspective....
12 Pages (3000 words) Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us