Unformatted text preview: as well as their employee number, date of birth, address, gender, salary and the department they are assigned to. Every project is assigned to a single department to be completed and a department will have many projects. Project information that is needed to manage the business includes the project name, the department it is currently allocated to, and the location of the office where the project is assigned. An employee may work on many projects that belong to both their department and other departments. To efficiently manage this, the each employee has an allocation that indicates the number of hours each employee has to spend per week on a particular project. Grading: • Entities – 2 points each (6 total) • Relationships – 2 points each (6 total) • Multiplicity – 2 points each (6 points total) • Attributes – 2 points total...
View Full Document
- Entity-relationship model, 75 minutes, Student Access ID., single department, Important employee information