Share on Google+Share on Google+

bharat sharma
refrential integrity
1 Answer(s)      6 years ago
Posted in : SQL

what is referntial integrity?

Ads

View Answers

April 5, 2011 at 11:28 AM


Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table. It also includes the techniques known as cascading update and cascading delete, which ensure that changes made to the linked table are reflected in the primary table.










Related Tutorials/Questions & Answers:
refrential integrity
refrential integrity  what is referntial integrity
What is an integrity constraint ?
What is an integrity constraint ?  What is an integrity constraint ?   An integrity constraint allows the definition of certain restrictions, at the table level, on the data that is entered into a table
Advertisements
Mysql Alter Foreign Key
integrity of the data. Understand with Example The Tutorial illustrate an example..._name' that add the referential integrity of the data from parent table
Java Glossary : Authorization
to maintain integrity, confidentiality or availability constraints. Java
MKS SCM for Eclipse
MKS SCM for Eclipse       MKS?s Integrity Solution, integrated with IBM WebSphere (Eclipse) enables development teams to analyze, build and deploy traditional
Transaction in JDBC
Description: It is a feature of JDBC Transactions to Preserve Data Integrity. Savepoint set the initialization position and the rollback unsaved all the change made starting from the savepoint where it is set. Here in this code you
Eclipse Plunging/Team Development
API" in the second generation of our Source Integrity / Eclipse integration
What is the use of CASCADE CONSTRAINTS?
What is the use of CASCADE CONSTRAINTS?   What is the use of CASCADE CONSTRAINTS?   Hi, The CASCADE CONSTRAINTS clause drops all referencial integrity constraints that refer to the primary and unique keys defined
Hi.. - Java Beginners
Hi..  Hi, I got some error please let me know what is the error integrity constraint (HPCLUSER.FAFORM24GJ2_FK) violated - parent key its very urgent  Hi Ragini can u please send your complete source
Web application - business layer
to maintain integrity and prevent data loss. What are the characteristics
java
classes and methods; often to enhance data integrity and prevent unauthorized
What is WTLS?
What is WTLS?  hii, What is WTLS?   hello, Wireless Transport Layer Security protocal (WTLS) does all cryptography oriented features of WAP. WTLS handles encryption/decryption, user authentication and data integrity
jdbc
the integrity of the database. Call Stored Procedure
What is Stored Procedure?
ensure the integrity of the database. e.g. sphelpdb, sprenamedb, sp_depends etc
Malware Threats in BYOD Environment
of challenges for company's integrity and privacy. When you bring your own smart... overall data security and integrity is the foremost step to improve security... the integrity issues concerning misuse of personal devices in workplace
SQL
integrity across nodes in a distributed database 3)Enforce complex business rules 4
SQL
)Automatically generate derived column values. 2)Enforce referential integrity
SQL
to: 1)Automatically generate derived column values. 2)Enforce referential integrity
SQL
)Automatically generate derived column values. 2)Enforce referential integrity across
Database
, primary key, foreign key, referential integrity, surrogate key and (if relevant
Editor?s Choice -AOP and IoC
concerns handles logging, transaction integrity, authentication, security, performance
Updated Releases
functionalities (Integrity, Confidentiality of non editable data and Generic Apache
Mysql Alter Constraint
to enforce the data integrity. This ensures the accuracy and reliability
use of ejb - EJB
beans support transaction to ensure the integrity of the database. Transaction
Java - JDBC
it defines the integrity constraint to hold the ACID PROPERTY
EJB 3.0 Tutorial
. Data Integrity : The application must have to ensure the data integrity while
Your competitor presses you to reveal some confidential information about your current or previous employer.
reason could be that the company is testing your integrity- if someone could cajole... willingness to co-operate and your integrity. Integrity has to be your choice... question. The interviewer is trying to get you choose between loyalty and integrity
Database Tutorial: Introduction to Database Relationships
is essential and need. Relationships and Referential Integrity: Just after adding... can enable and enforce the referential integrity with both the tables... of referential integrity. Check more tutorials at Database tutorials section
Database Management System (DBMS)
of the data. A DBMS is a system software package that ensures the integrity... ensures about data integrity despite concurrent user accesses and faults. It maintains the integrity of the data in the database by not allowing more than one
A programm for error free transmission of data using UDP in java
integrity, Encryption ... The transmitter shall: read data from file divide
Activation : Java Glossary
. This conversational state requires integrity in order to maintain the life of the bean?s service
Tutorials   
Java Spring Hibernate Struts Training How to Fetch Data using dropdown option How to get day from date in SQL? Example of sorting results in MySQL Distinct and Limit example in MySQL How to download install and use MySQL workbench? Example of Average, Sum, Min and Max functions in MySQL How to delete data from MySQL? Update SQL Query Example Order by example in MySQL AND and OR Operators in MySQL Query Where clause with query in MySQL How to use select Statement in MySQL? How to insert data into MySQL Table? Create Database and tables in MySQL example of before insert trigger in mysql Failed to Call Procedure MY Sql Query Error - Not able to Understand the issue which query will be run for previous(button) question How to access data yearly from DB in C# ? Fastest way to upload huge raw data in database - c#, Java or stored procedure DB Insert Nb hours between 2 time stamps meets specific criteria mysql select into table from another table example MySQLselect into new table Example code How to create a .mdf file from script (.sql) Please help me out fixing broken relational links in MySQL database after an upgrade How do I upgrade mysql? mysql 4.x to 5.x upgrade problem Upgrading a PHP/MYSQL application? upgrading sql query join phpmyadmin in whm whm php version update php cpanel cpanel mysql downgrade cpanel mysql version upgrade mysql whm upgrade mysql 4 5 cpanel upgrade mysql cpanel server Did my upgrade from mySQL 5.1 to 5.5 work Upgrade to MySQL 5.5 ? - cPanel Mem use upgrade from MySQL 5.1 to 5.5 - cPanel Upgrading MySQL from 5.0 to 5.1 or 5.5 - cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5)cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel Updating from MySQL 5.0 to 5.5 cPanel MySQL 5.1 upgrade to 5.5 error Charset problem upon publishing PHP + MySQL website MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist SQL Error Version 5.5.15

Ads

 
Advertisement null

Ads