GAQM Exam CBAF-001 Topic 2 Question 49 Discussion

Actual exam question for GAQM's CBAF-001 exam

Question #: 49
Topic #: 2

An analyst has discovered that a company wishes to hold information about departments and employees. A department may have many employees in it, but each employee can, at any one time, only work in one department. There is no requirement to store historical information. However, there are currently eight departments and over one hundred employees. How would this relationship be shown on an Entity Relationship diagram?

AAs (8 .. 100) at the Department end of the relationship.

BAs a many-to-many between Department and Employee.

CAs a one-to-one between Department and Employee.

DAs a one-to-many between Departmentand Employee.

Show Suggested Answer

Suggested Answer: A

by Brinda at Jun 21, 2024, 09:06 PM

Limited Time Offer

25%

Off

Get Premium CBAF-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jules

8 days ago

Hmm, let's see. Many departments, one employee per department. Sounds like a one-to-many relationship to me. Option D is the way to go, folks!

upvoted 0 times

...

Juliann

10 days ago

This is a straightforward question. The given information clearly indicates a one-to-many relationship between Department and Employee. Option D is the way to go.

upvoted 0 times

...

Tayna

18 days ago

Option D is the correct answer. The relationship between Department and Employee is one-to-many, as each department can have many employees, but each employee can only work in one department at a time.

upvoted 0 times

Lindsey

5 days ago

D) As a one-to-many between Department and Employee.

upvoted 0 times

...

Francine

19 days ago

I disagree. I believe it should be shown as a many-to-many between Department and Employee, as a department can have many employees and an employee can work in multiple departments.

upvoted 0 times

...

Francisca

20 days ago

I agree with Buck. Each employee can only work in one department, so it makes sense to have a one-to-many relationship.

upvoted 0 times

...

Buck

21 days ago

I think the relationship should be shown as a one-to-many between Department and Employee.

upvoted 0 times

...