View the step-by-step solution to:

In the table Employee, each row contains data about an employee. The primary key is Empno. The attribute Empdeptno is a foreign key referring to the...

In the table Employee, each row contains data about an employee. The primary key is Empno. The attribute Empdeptno is a foreign key referring to the department number (Deptno. of the table Department.



.


8. Which of the following columns of the table Department is a foreign key?
A) Deptno
B) Deptname
C) Deptcity
D) Deptmgr


9. Which of the following columns is not a foreign key?
A) Projno in table Project
B) Projmgr in table Project
C) Prstno in table Projstaff
D) Prstempno in table Projstaff



10. If the combination Prstno, Prstempno is chosen as the primary key for table Projstaff, setting Prstno to null in some row would be:
A) A violation of the entity integrity rule
B) A violation of the referential integrity rule
C) A violation of the entity integrity rule and of the referential integrity rule
D) None of the above
Sign up to view the entire interaction

Top Answer

The way to answer this question is ... View the full answer

solution46.docx

8D
9A
10 A

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online