Recent questions tagged referential-integrity

Consider relation $S(D,E)$ with primary key $(D,E)$.The current instance of $S$ contains $(1,3)$, $(2,4)$, $(3,1)$.Relation $R(A,B,C)$ contains the foreign-key constraint...

Consider the relations $Parent(pid)$ and $Child(cid,pid)$where $Parent.pid$ is the primary key and $Child.pid$ is a foreign key referencing $Parent.pid$No cascading actio...

Let $R(A,B,C)$ be a referencing relation and $S(D,E)$ be a referenced relation.Suppose $B$ is a foreign key of $R$ that references the candidate key $D$ of $S$.Which of t...

Consider two relations $r$ and $s$ defined on the relational schemas $R(A, B)$ and $S(E, C)$, respectively. $A$ is the primary key of $R$ and $E$ is a foreign key of $S$ ...

Consider the two relations below. The primary keys are underlined. Identify all possible foreign key(s) from the options based only on the two relations.$\text{EMP (eid, ...

Mention which of the following is a special type of integrity constraint that relates two relations & maintains consistency across the relations.Entity Integrity Constrai...

Domain constraints, functional dependency and referential integrity are special forms of _______Foreign keyPrimary keyAssertionReferential constraint

Following table has two attributes Employee_id and Manager_id, where Employee_id is a primary key and manager_id is a foreign key referencing Employee_id with on-delete c...

How to represent referential integrity constraint in ER model?pls explain with diagram

Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential ...

select the correct statement from the following on referential integritySelect one:a. referential integrity constraints check whether the primary key, values are uniqueb....

Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential ...

Match the following with respect to RDBMS :$\begin{array}{clcl} \text{(a)} & \text{Entity integrity} & \text{(i)} & \text{enforces some specific business rule that do not...

Explain recursive foreign key with suitable example..

We can convert any weak entity set to a strong entity set by simply adding appropriate attributes. Why, then, do we have weak entity sets at all? $1)$ We want to avoid th...