BCS-ISEB
ISEB-BA1 · Question #6
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…
The correct answer is D. As a one-to-many between Department and Employee. See the full explanation below for the reasoning.
Question
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?
Options
- 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 Department and Employee.
How the community answered
(42 responses)- A2% (1)
- B5% (2)
- C10% (4)
- D83% (35)
Community Discussion
No community discussion yet for this question.