Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Database Questions

image text in transcribedimage text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learning PostgreSQL

Authors: Salahaldin Juba, Achim Vannahme, Andrey Volkov

1st Edition

178398919X, 9781783989195

More Books

Students also viewed these Databases questions

Question

LO4 Specify how to design a training program for adult learners.

Answered: 1 week ago