Implement a matrix approach for project teams

Reference no: EM133662128

Information Visualization

Assessment - Conceptual modelling

Overview

Task description:
Foundational to addressing business concerns is an understanding of core concepts, principles and skills required for understanding, designing, and managing databases. This implies understanding the kinds of techniques that are used to model data and an ability to develop a concise conceptual model that represents a given universe of discourse.

This assessment will involve creating a conceptual schema design for a given universe of discourse and the generation of a relational mapping.

Task 1a and Task 1b - Group

WGM employs many employees in several departments and maintains information about their project team staff and the projects that they work on.

Perform CSDP steps 1 - 6 and submit your final ORM diagram (you are 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 any 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 is given a Project Role. An employee will only have one role within a project. Depending on the nature of the project and the skills 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.

Tips and Hints
Please note that in the story of the UoD, some values or entity types are mentioned in the above scenario but may not be included in the details below. This is a deliberate omission, and you can make reasonable assumptions about the data.
- Keep things simple. and do not overcomplicate the scenario.
- Avoid adding additional information into the scenario, stick to what you have been given.

The project details are reported and include important aspects, including a description and other relevant information needed to identify and track the project.

The information recorded includes the project name. duration. and team details such as name, department and 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.

Task 2 - Group

Following is an ORM model for customers. Map the schema to a relational database schema. Any possible constraints need to be included (e.g.. primary key, foreign key).

Write the relations clearly, showing the Primary key in bolded and underlined (e.g., Customerld).

The foreign key is shown in italics (e.g.. OrderNumber ) and separately defined beneath the relation (e.g. ShoppingCart OrderNumber FK to Order OrderNumber).

This assessment is to be completed in groups of 2 (exceptions may be made with the approval of the teaching team). Group members should belong to the same tutorial group.

You will have to solve two tasks:

Task 1a. Present a list of elementary facts that fully and explicitly verbalise the fact types contained in the scenario description.
Task 1b. Apply the Conceptual Schema Design Procedure (steps 1 - 7) to a given business concern (group task)

Task 2. Map a conceptual schema design to a relational database schema (RMapping)

For task 1, you can use any modelling tool (including MS PowerPoint. Luc idChart, Draw.io or clearly handwritten) to draw your models. Make sure the diagrams are readable, clearly labelled and based on the above scenario.

Attachment:- Assignment - Conceptual modelling.rar

Reference no: EM133662128

Questions Cloud

Strategic planning and social responsibility : Explains the relationship between strategic planning and social responsibility?

What effectiveness approach would you prefer : Explain the ways that these types of goals may conflict in an organization? What effectiveness approach would you prefer?

Managing project using new approach for your organization : You are managing a project using a new approach for your organization. There are three distinct phases that are divided into several short iterations,

Clinton has already noticed us-versus-them mentality : Clinton has already noticed an us-versus-them mentality among the various units on the floor.

Implement a matrix approach for project teams : INF 554 Information Visualization, University of Southern California Assessment implemented a matrix approach for project teams. In a matrix organization

Human resources office is third door on the right : The Human Resources Office is the third door on the right, Room C-502. In which building is the Human Resources Office located?

Five vendor proposals are being considered : Five vendor proposals are being considered for a new information technology contract.

What we have learned from the crisis : What were the main causes, what we have learned from the crisis and how has financial sector changed since then?

Explain the major types of health insurance and assess : Explain the major types of health insurance and assess organizational financial performance related to nongovernmental payer models.

User Account

All Pages