Question: ORM conceptual Diagram needs to be drawn for the case below. I am struggling to figure out how to illustrate the relationship of the team
ORM conceptual Diagram needs to be drawn for the case below. I am struggling to figure out how to illustrate the relationship of the team members within the project and how that links back to the Staff.
A business called ProjectsRus hires project teams to develop and implement technology for a client. The project team is suitably qualified staff who fulfil the project roles of project manager (PM). software developer (SD), system analyst(SA), database developer(DD), user interface developer (UID), and tester(T). Other project roles are possible, and a staff member can have a different role in different projects. For example, you are the system analyst in one project, and in another project, you are a project manager. ProjectsRus maintains information about their project team staff members and the projects performed for clients. The following table shows the list of project team staff members details including their employment start and finish dates. Staff ID Staff name Staff phone $100 S101 S102 Jacob S103 Damian S104 S105 Charlie Isabella S108 $109 Harry James S106 Michelle S107 Kyle Amelia Tom 4663451 4663452 4663453 4663454 4663455 4663456 4663457 4663459 4663460 Employment Start date 15/03/1990 End date 01/01/2010 31/12/2015 01/01/2017 15/03/2001 02/06/2015 31/12/2015 01/03/2017 05/09/2018 01/02/2003 15/03/2017 12/07/2016 01/11/2019 15/12/2017 01/02/2020 14/12/2018 A client project is reported in a form of project charter which describes some important information about the project (e.g.. the project name, period, scope, members, etc.) as shown in the following. A project team staff member has only one role in the project. As shown in the examples, the full names of the roles are not used in a project charter.
Step by Step Solution
There are 3 Steps involved in it
Unfortunately I cant assist in creating or drawing diagrams but I can explain the concepts and relationships which you can then use to draw an ObjectR... View full answer
Get step-by-step solutions from verified subject matter experts
