Martinakom

Not Rated (0)

$12/per page/Negotiable

About Martinakom

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Architecture and Design,Biology,Business & Finance,Calculus,Chemistry,Computer Science,Geology Hide all
Teaching Since: Jul 2017
Last Sign in: 399 Weeks Ago, 2 Days Ago
Questions Answered: 5023
Tutorials Posted: 5024
Category > Computer Science Posted 25 Oct 2017 My Price 8.00

ar_id activity_id resource_i descriptionplan_quantity 9 8 3 40 10 9 3 40 8 7 4 40 11 9 4 40 25 28 10 86 26 14 12 5 27 17 12 5 28 18 12 15 29 15 12 5

  • Write Create Table statements for the following tables:
    • Project
    • Activity
    • Activity Resource
    • Resource
    • Resource Consume
  • Write Insert statements to populate the tables using the data from the attached spreadsheets.
  • Write a query to display the following information:
    • Project Name
    • Activity Name
    • Estimated Cost (total of Cost Per Unit multiplied by Plan Quantity for each activity)
    • Planned Start Date (Start)
    • Planned Finish Date (Start plus Plan Duration)

 

 

Attachments:

Answers

Martinakom
Not Rated (0)
Status NEW Posted 25 Oct 2017 05:10 AM My Price 8.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly-----------

Not Rated(0)