Question
WGM employs many employees in several departments and maintains information about their project team staff and the projects that they work on. Perform CSDP step
WGM employs many employees in several departments and maintains information about their project team staff and the projects that they work on.
Perform CSDP step 1 ~ 6 and submit your final ORM diagram (not required to submit the results of the interim steps only the final diagram) for the following business concern.
WGM business concern
A modern white goods manufacturing company (WGM) employs many employees in several departments such as Product Design (PD), Manufacturing (M), Information Technology (IT), Sales & Marketing (SM), Finance and Accounting (FA), and Human resources (HR). Each of these departments has a department manager (DM). The chief executive officer (CEO) has implemented a matrix approach for project teams. In a matrix organization, project team members report to a project manager (PM) as well as their department manager. This allows the WGM company to solve problems using a project team without having to realign the department.
With each new project the PM selects the expertise needed and contacts each of the departments to locate and available staff member. The team then comes together to work on the project and once completed is returned to the available pool ready for the next assignment. Whilst on the project, each of the employees are given a Project Role. An employee will only have one role within a project. Depending on the nature of the project and the skill required, some employees may be on multiple projects at the same time.
The following table shows a sample list of employees including their departments and their employment start and finish dates.
Employee ID | Employee Name | Employee Mobile | Department | Employment | |
Start date | End date | ||||
P3201 | David | 0149 634 514 | PD | 15/04/1991 |
|
P3202 | Anjali | 0146 634 527 | IT | 01/02/2011 | 31/12/2014 |
01/02/2018 |
| ||||
P3203 | Jack | 0148 346 539 | M | 15/04/2002 |
|
P3204 | April |
| SM | 02/07/2016 | 31/12/2017 |
01/04/2018 | 05/09/2018 | ||||
P3205 | Hermione | 0146 734 551 | IT | 01/03/2004 |
|
P3206 | Blake |
| M | 15/04/2018 | 14/12/2018 |
P3207 | Sophia | 0149 634 573 | FA | 12/08/2017 |
|
P3208 | Kelly |
| PD | 01/12/2020 |
|
P3209 | Ali | 0145 634 595 | M | 15/11/2018 |
|
P3210 | Callum | 0146 637460 | M | 01/03/2021 |
|
P3211 | Arthur | 0415 987 256 | HR | 05/02/2000 |
|
P3212 | Sev | 0413 784 512 | FA | 06/12/2019 |
|
P3213 | Aiden | 0414 784 256 | SM | 24/08/1999 |
|
The project details are reported and include important aspects including a description and other relevant information needed to identify and track the project. Information recorded includes the project name, duration, and the team details such as name, department and their role within the project.
A project team employee has only one role in the project. As shown in the examples, the project roles are used in a project description.
Project Role | Code |
Project Manager | PM |
Software Developer | SD |
System Analyst | SA |
Database Developer | DD |
User Interface developer | UID |
Tester | T |
Below are 2 examples of the Project Description records - these records are a summary of the initial key project information.
During the execution of a project any project team employee that leaves WGM will be replaced by another employee.
Project Description (Example 1) | |||
Project ID | PRJ1001 | ||
Project Name | Touchpad interface integration | ||
Project Sponsor | Research & Development | ||
Start Date | 01/02/2020 | Budget | $1 mil AUD |
Project Description | Touchpad interface integration improvement with touch sensors | ||
Project Duration (years) | Two | ||
Scope | Touchpad interface with motion and proximity sensors.... Note: More details including deliverables would be developed in the project documentation and not needed here on the description | ||
..... | |||
Project Members | Role | Name | |
PM SA SD UID DD SA | Sev (P3212) David (P3201) Jack (P3203) Ali (P3209) Sophia (P3207) Anjali (P3202) | ||
Total Number | 6 |
Project Description (Example 2) | ||||
Project ID | PRJ1057 | |||
Project Name | Dry and wash sensory upgrade | |||
Project Sponsor | Whitegoods | |||
Start Date | 15/05/2018 | Budget | $ 75 000.00 AUD | |
Project Description | Combination sensory upgrade | |||
Project Duration (years) | One | |||
Scope | Sensory detection upgraded to extend levels. Mobile application sensory control application... Note: More details including deliverables would be developed in the project documentation and not needed here on the description. | |||
..... | ||||
Project Members | Role | Name | ||
PM | Hermione (P3205) | |||
UID | David (P3201) | |||
SA | Jack (P3203) | |||
DD | Blake (P3206) | |||
SD | Anjali (P3202) | |||
| Total Number | 5 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Solution Creating an ObjectRole Model ORM diagram involves several steps in the Conceptual Schema De...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