Case Study

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