Please see the attached excel spreadsheet and word doc. Thanks

7
4 Create Procedures
8
4 Create Software
9
4 Implement Procedures and Software
14
7 Create Test Cases
15
7 Move to live site
16
7 Fix bugs as they appear
17
7 Identify Errors
18
7 Fix Errors
28
9 Create Completed Project
29
9 Template Dashboard Ready start plan_duratwbs_id
1/1/2017
7
1/8/2017
7
1/15/2017
14
1/26/2017
7
3/2/2017
7
3/9/2017
28
2/2/2017
7
2/9/2017
21
1/24/2017
63
2/9/2017
1 8
9
10
15
16
17
15
15
27
27 parent_id display_or actual_start
actual_end
percent_complete
0 NULL
1/1/2017
1/11/2017
1
0 NULL
1/9/2017
1/16/2017
1
0 NULL
1/16/2017 0000-00-00
0.1
0 NULL
1/26/2017
2/12/2017
1
0 NULL
NULL
NULL
NULL
0 NULL
NULL
NULL
NULL
0
1
2/9/2017 0000-00-00
0.5
0
2 NULL
NULL
NULL
0 NULL
1/24/2017 0000-00-00
0.2
0
1 NULL
NULL
NULL ar_id activity_id
9
10
8
11
25
26
27
28
29
30 resource_id
8
9
7
9
28
14
17
18
15
16 description
3
3
4
4
10
12
12
12
12
12 plan_quantity
40
40
40
40
86
5
5
15
5
20 project_id project_name
4 Process Improvement
7 NM Fashion Migration
9 Apple TV Project wbs_finalized wp_id
1
1
1 2
2
15 resource_id project_id
3
4
10
12 resource_name
4 Programming
4 Consulting
9 Programming
7 Development measurement
Hour
Hour
Hour
Hour cost_per_unit
100
200
15
15 rc_id ar_id
13
12
15
14
19
20
35
36
21
22
37 quantity
9
8
8
11
25
25
25
25
26
26
28 consume_date
9
1/5/2017
1
1/8/2017
9
1/9/2017
1
1/9/2017
16
2/2/2017
0.5
2/2/2017
3
2/9/2017
3
2/9/2017
1
1/26/2017
1
1/26/2017
0.5
2/16/2017

Attached files in Excel Spreadsheet:
Activity.xlsx
Activity_resource.xlsx
Project.xlsx
Resource.xlsx
Resource_consumer.xlsx Given the following ERD from a project management information system: Do the following: Write Create Table statements for the following tables:
o Project
o Activity
o Activity Resource
o Resource
o Resource Consume Write Insert statements to populate the tables using the data from the attached
spreadsheets. Write a query to display the following information:
o Project Name
o Activity Name
o Estimated Cost (total of Cost Per Unit multiplied by Plan Quantity for each
activity)
o Planned Start Date (Start)
o Planned Finish Date (Start plus Plan Duration) To write your SQL statements, I would suggest using a free online tool, SQL FIDDLE. You can
write the Create Table and Insert statements in the Schema Panel and then run your query to
accomplish the last part of the problem in the other panel.Attached files in Excel Spreadsheet:
Activity.xlsx
Activity_resource.xlsx
Project.xlsx
Resource.xlsx
Resource_consumer.xlsx Given the following ERD from a project management information system: Do the following: Write Create Table statements for the following tables:
o Project
o Activity
o Activity Resource
o Resource
o Resource Consume Write Insert statements to populate the tables using the data from the attached
spreadsheets. Write a query to display the following information:
o Project Name
o Activity Name
o Estimated Cost (total of Cost Per Unit multiplied by Plan Quantity for each
activity)
o Planned Start Date (Start)
o Planned Finish Date (Start plus Plan Duration) To write your SQL statements, I would suggest using a free online tool, SQL FIDDLE. You can
write the Create Table and Insert statements in the Schema Panel and then run your query to
accomplish the last part of the problem in the other panel.

• 1493254510-Copy of activity-1.xlsx
• 1493254512-Questions.docx

ComputerScienceExpert

(11)

Status NEW Posted 27 Apr 2017 12:04 AM My Price 9.00

-----------

Attachments

file 1493254513-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer