Question
Say there is a consulting company that assigns its employees to work on various projects. Suppose an employee is assigned to only one project at
Say there is a consulting company that assigns its employees to work on various projects. Suppose an employee is assigned to only one project at a time. But over time, an employee can work on multiple projects. On a project there can be multiple employees at the same time. The manager would like to know, given a past or current project, which employees were assigned to or currently assigned to on that project and given an employee which projects have they worked on in the past or working in the present. Suppose a database is needed to answer the queries of the manager. Identify the entities and entity types in this situation. Identify the relationships between those entity types. Draw an ER diagram (without the attributes) for this situation. Show the associative entity and the maximum and minimum cardinalities for each relationship.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started