Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Databases questions

Question

c. Are there any prerequisites for the course?

Answered: 1 week ago

Question

What are the APPROACHES TO HRM?

Answered: 1 week ago

Question

What do you mean by dual mode operation?

Answered: 1 week ago

Question

Explain the difference between `==` and `===` in JavaScript.

Answered: 1 week ago

Question

What is data falsification?

Answered: 1 week ago