The following data are in the tables Employee (primary key: Empno) and Departmen

Question

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.

An inner join only returns matched records from the tables that are being joined.

  True False

Which of the following columns of the table Department is a foreign key?

A. Deptno

B. Deptname

C. Deptcity

D. Deptmgr

The values shown in the table Department:

A. violate neither the entity integrity rule nor the referential integrity rule

B. violate the entity integrity rule

C. violate the referential integrity rule

D. violates both the entity integrity rule and the referential integrity rule

Explanation / Answer

An inner join only returns matched records from the tables that are being joined.

  True

Which of the following columns of the table Department is a foreign key?

Ans: D. Deptmgr

For other two question, I need table Department. Please post

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.