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...
-
How many people learned of the sale from exactly one of the three media? A merchant surveyed 400 people to determine from what source they found out about an upcoming sale. The results of the survey...
-
A partnership of attorneys in the St. Louis, Missouri, area has the following balance sheet accounts as of January 1, 2013: Assets .........$320,000 Liabilities ..........$120,000 Athos, capital...
-
Air-conditioning machine operates on the principle of (a) Second law of thermodynamics (b) Zeroth law of thermodynamics (c) First law of thermodynamics (d) Third law of thermodynamics
-
1. In which section of the Comprehensive Annual Financial Report (CAFR) are the budget-to-actual comparisons of the major funds? a. Which accounting basis did the City follow to prepare its annual...
-
A bathtub can hold 35 gallons of water. The faucet has a flowrate of 5 gallons per minute. Calculate how long it takes to fillthe bath tub if it was initially empty. Also calculate the...
-
Using a linear programming framework and the data from case Exhibit 1, formulate and solve the problem of finding the cost-minimizing set of bids that meet Mars' business requirements and determines...
-
Morgan manufactures a product Z and provides the following information for the last month: Budgeted figures: Variable manufacturing overheads R20 000 Fixed manufacturing overheads R48 000 Labour...
-
Cairo Corporation has government bonds classified as held-for-collection at December 31, 2015. These bonds have a par value of \($800\),000, an amortized cost of \($800\),000, and a fair value of...
-
Weisberg Corporation has 10,000 shares of \($100\) par value, 6%, preference shares and 50,000 ordinary shares of \($10\) par value outstanding at December 31, 2015. Instructions Answer the questions...
-
Loxley Corporation is authorized to issue 50,000 shares of \($10\) par value ordinary shares. During 2015, Loxley took part in the following selected transactions. 1. Issued 5,000 shares at \($45\)...
-
On January 2, 2015, Jones Company purchases a call option for \($300\) on Merchant ordinary shares. The call option gives Jones the option to buy 1,000 shares of Merchant at a strike price of \($50\)...
-
Derrick Company issues 4,000 restricted shares to its CFO, Dane Yaping, on January 1, 2015. The shares have a fair value of 120,000 on this date. The service period related to these restricted shares...
-
You and your business partner have launched your own company. Business is going very well, and the two of you are now trying to make decisions about marketing and production and accounting. Regarding...
-
Michelles trust is subject to 3.8% surtax on the lesser of the trusts net investment income or the excess of the trusts adjusted gross income over the $12,400 threshold (the highest trust tax rate)....
-
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...
-
The 8-kg body is moved \(0.2 \mathrm{~m}\) to the right of the equilibrium position and released from rest at time \(t=0\). Determine its displacement at time \(t=2 \mathrm{~s}\). The viscous damping...
-
The two fixed counterrotating pulleys are driven at the same angular speed \(\omega_{0}\). A round bar is placed off center on the pulleys as shown. Determine the natural frequency of the resulting...
-
A 50-kg instrument is supported by four springs, each of stiffness 7500 \(\mathrm{N} / \mathrm{m}\). If the instrument foundation undergoes harmonic motion given in meters by \(x_{B}=0.002 \cos 50...
Study smarter with the SolutionInn App