Database - The Relational Model and Normalization - Discussion
Discussion Forum : The Relational Model and Normalization - General Questions (Q.No. 7)
7.
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Discussion:
8 comments Page 1 of 1.
Karthi said:
1 decade ago
Key is refer another table so it should be referential integrity.
(1)
Rose said:
1 decade ago
The foreign key imposes a constraint where the value primary key attribute in referential table can only be the values of the foreign key in the primary table.This constraint is called the referential key constraint.
Vimalesh said:
1 decade ago
The foreign key imposes a constraint where the value primary key attribute in referential table can only be the values of the foreign key in the primary table. This constraint is called the referential key constraint.
Ritesh said:
1 decade ago
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.
Lotus said:
8 years ago
Key refers another table.
Md Didarul Islam said:
7 years ago
Thanks for explaining.
Asamoah kwame said:
6 years ago
Thanks for explaining.
Benard ndenza said:
2 years ago
@ALL.
You can not add data in a table in which the key acted as a foreign key before being added to the table where it is a primary.
You can not add data in a table in which the key acted as a foreign key before being added to the table where it is a primary.
(1)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers