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 #6 of table Employee violates neither the entity integrity rule nor the referential integrity rule.
B) Row #6 of table Employee violates the entity integrity rule.
C) Row #6 of table Employee violates the referential integrity rule.
D) Row #6 of table Employee violates both the entity integrity rule and the referential integrity rule.
Correct Answer:
Verified
Q49: The tables Dept1 and Dept2
Q50: To ensure that a database contains valid
Q51: In the alternative terminology for relational databases,the
Q52: For each column in a table,the _
Q53: A relational algebra operator produces the
Q55: A relational algebra operator produces the
Q56: The Intersection of a table of N
Q57: The following data are in the
Q58: The following data are in the
Q59: When the extended cross product operation is
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