You are a backend developer for a Global Consulting Firm global_consult.com, and are responsible for implementing...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a backend developer for a Global Consulting Firm global_consult.com, and are responsible for implementing a MySQL database system. Your task is to design and develop a web application allowing the firm's employees to perform the following functions: • Create projects defining the client company, the recommended end date, the knowledge domain required for phase A of the project, and knowledge domain for phase B. (the consulting firm specializes in a limited number of domains including IT, Finance, Change Management) • Additional attributes are needed to update projects' status, which progresses through the following steps - "not started", "phaseA_1", "phaseA_2", "phaseB_1", "phaseB_2", "completed". . . . Setup client profiles with standard information such as client-company name, company division, contact person, email, password. Note: Clients are Companies not individuals, although a contact person from a Client Company sets up and manages the client profile on behalf of that Company. (b) (c) (a) For the global_consult database, create an Entity Relationship Diagram (ERD), using crow's foot notation. Entities, relationships between entities, and appropriate association types should all be included in your diagram. Use the minimum number of table that provide for the required database functionality. [10] For each table of the database you designed in (a), list the primary and foreign keys. (d) Consultants are employees of the Global Consulting firms, who contribute to projects according to their competencies. One of the functionalities of the web application is creating consultant_allocations deal with the booking of consultants to projects, based on competency domains of consultants, and progress status of projects. At any point in time, a consultant can contribute to at most one project. A client can create several projects. A created project can then start at any time but must be completed by the recommended end date. Once a project has started, each one of steps "phaseA_1" through "phaseB_2" takes one month. Each consultant has one high-competency knowledge domain, and one medium- competency domain. Consultants are only booked on and contribute to projects during steps requiring their competencies, with a priority on high-skilled contributions. Create the tables you designed in your answer to part (a) with appropriate SQL code. [14] Give scenarios how a Project Leader can benefit from the database you have created, when he selects a project's start date and contributors throughout project's life. [2] You are a backend developer for a Global Consulting Firm global_consult.com, and are responsible for implementing a MySQL database system. Your task is to design and develop a web application allowing the firm's employees to perform the following functions: • Create projects defining the client company, the recommended end date, the knowledge domain required for phase A of the project, and knowledge domain for phase B. (the consulting firm specializes in a limited number of domains including IT, Finance, Change Management) • Additional attributes are needed to update projects' status, which progresses through the following steps - "not started", "phaseA_1", "phaseA_2", "phaseB_1", "phaseB_2", "completed". . . . Setup client profiles with standard information such as client-company name, company division, contact person, email, password. Note: Clients are Companies not individuals, although a contact person from a Client Company sets up and manages the client profile on behalf of that Company. (b) (c) (a) For the global_consult database, create an Entity Relationship Diagram (ERD), using crow's foot notation. Entities, relationships between entities, and appropriate association types should all be included in your diagram. Use the minimum number of table that provide for the required database functionality. [10] For each table of the database you designed in (a), list the primary and foreign keys. (d) Consultants are employees of the Global Consulting firms, who contribute to projects according to their competencies. One of the functionalities of the web application is creating consultant_allocations deal with the booking of consultants to projects, based on competency domains of consultants, and progress status of projects. At any point in time, a consultant can contribute to at most one project. A client can create several projects. A created project can then start at any time but must be completed by the recommended end date. Once a project has started, each one of steps "phaseA_1" through "phaseB_2" takes one month. Each consultant has one high-competency knowledge domain, and one medium- competency domain. Consultants are only booked on and contribute to projects during steps requiring their competencies, with a priority on high-skilled contributions. Create the tables you designed in your answer to part (a) with appropriate SQL code. [14] Give scenarios how a Project Leader can benefit from the database you have created, when he selects a project's start date and contributors throughout project's life. [2]
Expert Answer:
Answer rating: 100% (QA)
Answer SQL code is as follow Create Client table CREATE TABLE Client clientid INT PRIMAR... View the full answer
Related Book For
Systems Analysis and Design in a Changing World
ISBN: 978-1305117204
7th edition
Authors: John W. Satzinger, Robert B. Jackson, Stephen D. Burd
Posted Date:
Students also viewed these computer network questions
-
What trade policy instruments does Japan's government currently employ? Which theory/theories of international trade does this use of trade policy instruments support? Explain using illustrative...
-
Hyten Corporation On June 5, 1998, a meeting was held at Hyten Corporation, between Bill Knapp, Director of Marketing/Sales, and John Rich, director of engineering. The purpose of the meeting was to...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
By applying modern technology to agriculture, the United States has become the most productive food-producing nation in the world. The secret to solving the world food security problem lies in...
-
Experiments have shown that thought processes in the brain can be affected if the parietal lobe is exposed to a magnetic field with a strength of 1.0 T. How much current must a long, straight wire...
-
Cool Sound Ltd. manufactures a line of amplifiers that carry a three-year warranty against defects. Based on experience, the estimated warranty costs related to dollar sales are as follows: first...
-
Which of the following arguments is most likely to be used in terms of having information systems auditors perform a staff role within an organization: a. Makes better use of scarce information...
-
Hart Company made 3,000 bookshelves using 22,000 board feet of wood costing $266,200. The companys direct materials standards for one bookshelf are 8 board feet of wood at $12 per board foot. Compute...
-
At the beginning of Year 3, Dyer chooses to change its method of accruing for product recalls. Consistent with the majority of the industry, Dyer will begin accruing a liability for product recalls...
-
Carrie DLake, Reed A. Green, and Doug A. Divot share a passion for golf and decide to go into the golf club manufacturing business together. On January 2, 2020, DLake, Green, and Divot form the...
-
1. Choose one of the documents in the world of your work, then take a photo, and find 10 misspellings in the document, then analyze!
-
Part I - use g = 10m/s 1. The movie "The Gods Must Be Crazy" begins with a pilot dropping a bottle out of an airplane. It is recovered by a surprised native below, who thinks it is a message from the...
-
Dennis Rodman has a $4,000 debt balance on his Visa card that charges an APR of 12.7 percent compounded monthly. Dennis's current minimum monthly payment is 3 percent of his debt balance, $120. How...
-
Zellars, Inc. is considering two mutually exclusive projects, A and B . Project A costs $ 9 5 , 0 0 0 and is expected to generate $ 6 5 , 0 0 0 in year one and $ 7 5 , 0 0 0 in year two. Project B...
-
How do the psychological phenomena of loss aversion and the endowment effect influence stakeholder perceptions and attitudes towards impending organizational change initiatives, and what mechanisms...
-
Find 4-6 obituaries (your dataset) to analyze. (Please avoid obituaries of people you might know. This exercise should help flex your researcher muscles, so objectivity, as much as is possible, is...
-
The manufacturing company Soluciones Elctricas has the following variable cost information to record the variations of the accounting period: 1. The total of the real costs incurred is $1,578,400.00....
-
Pearl Medavoy will invest $10,240 a year for 20 years in a fund that will earn 10% annual interest. . If the first payment into the fund occurs today, what amount will be in the fund in 20 years? If...
-
Describe in your own words how an object-oriented program works.
-
Explain how net present value (NPV) is calculated.
-
Figure 13-32 is an activity diagram for the use case Return books in the university library system. Do the following: a. Develop a first-cut sequence diagram that only includes the actor and problem...
-
Total quality management (TQM) is based on four tenets of (1) continuous improvement, (2) employee participation, (3) product/service improvement, and (4) supplier relationships. Review each of the...
-
Better Health Inc. is a health care provider which has clinics across the U.S. Indicate whether each of the following examples of benchmarking for Better Health is considered (1) internal...
-
The Malcolm Baidrige National Quality Award (Baldrige Award) requires applicants to demonstrate excellence in each of the following seven categories: (1) leadership; (2) strategic planning; (3)...
Study smarter with the SolutionInn App