Database Questions In ABC Company, an employee can work on multiple projects. Th

Question

Database Questions

In ABC Company, an employee can work on multiple projects. There are times when an employee is not assigned to any project. Each project should have one or more employees working on it Based on this description, please answer questions 1 through 3 about the relationship between the classes PROJECT and EMPLOYEE 1) The cardinalities for EMPLOYEE PROJECT and PROJECT- EMPLOYEE are A) 0:N for EMPLOYEE PROJECT and 0:N for PROJECT- EMPLOYEE B) 0:N for EMPLOYEE PROJECT and 1:N for PROJECT EMPLOYEE C 1:N for EMPLOYEE PROJECT and 0:N for PROJECT- EMPLOYEE D) 1:N for EMPLOYEE PROJECT and 1:N for PROJECT EMPLOYEE E) 1:1 for EMPLOYEE PROJECT and 1:N for PROJECT EMPLOYEE 2) The Optionality for EMPLOYEE PROJECT and PROJECT EMPLOYEE are A) 0 for EMPLOYEE PROJECT and 0 for PROJECT- EMPLOYEE B) 1 for EMPLOYEE PROJECT and 0 for PROJECT- EMPLOYEE C) 1 for EMPLOYEE PROJECT and 1 for PROJECT- EMPLOYEE D) 0 for EMPLOYEE PROJECT and 1 for PROJECT- EMPLOYEE E) 2 for EMPLOYEE PROJECT and 1 for PROJECT- EMPLOYEE 3) The Relationship between EMPLOYEE and PROJECT is A ONE ONE BO MANY MANY C ONE MANY D) ZERO-ZERO E) None of the above

Explanation / Answer

1. D) 1:N for EMPLOYEE --> PROJECT AND 1:N FOR PROJECT --> EMPLOYEE

3. C) ONE-MANY

5. B) Optionality cab be more than 1

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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