The following data are in the tables Employee (primary key: Empno) and Department (primary key: Deptno) . The questions refer to row numbers of this table. The first row of each table is row #1. Empdeptno in table Employee is a foreign key that refers to Deptno in the table Department. Deptmgr in the table Department is a foreign key that refers to Empno in the table Employee.
-Which of the following statements is true?
A) Row #7 of table Employee violates neither the entity integrity rule nor the referential integrity rule.
B) Row #7 of table Employee violates the entity integrity rule.
C) Row #7 of table Employee violates the referential integrity rule.
D) Row #7 of table Employee violates both the entity integrity rule and the referential integrity rule.
Correct Answer:
Verified
Q53: A relational algebra operator produces the
Q54: The following data are in the
Q55: A relational algebra operator produces the
Q56: The Intersection of a table of N
Q57: The following data are in the
Q59: When the extended cross product operation is
Q60: In the set-oriented database terminology,a(n)_ is synonymous
Q61: A(n)_ is an operator that includes in
Q62: A(n)_ is an operator that includes in
Q63: A(n)_ set operator retrieves all rows in
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents