Welcome

Anti Essays offers essay examples to help students with their essay writing.

Sign Up

Case Study 2.2

Open Document

Below is a free excerpt of "Case Study 2.2" from Anti Essays, your source for free research papers, essays, and term paper examples.

Problem 8
Provide a list all projects which ended on December 1, 1982. Display the year and month of the starting date and the project number. Sort the result by project number.
Name the derived columns YEAR and MONTH.
Result
YEAR MONTH PROJNO
------------+--------------------------+------------------------
1982 1 MA2111
1982 1 MA2112
1982 2 MA2113
ANSWER:SELECET YEAR (PRSTDATE) AS YEAR, MONTH(PRSTDATE) AS MONTH,PROJNOFROM PROJECTWHERE PRENDED = ‘1982-12-01’ORDER BY PROJNO |

PROBLEM 9
List the project number and duration, in weeks, of all projects that have a project number beginning with MA. The duration should be rounded and displaed with one decimal.
Name the derived column WEEKS.
Order the list by the project number.
Result
PROJNO WEEKS
---------------------+----------------------------
MA2100 56.6
MA2110 56.6
MA2111 47.7
MA2112 47.7
MA2113 41.3

ANSWER:SELECT PROJNO,DECIMAL ((DAYS (PRENDATE) * DAYS (PRSTDATE) /7.0+0.05,8,1) AS WEEKSFROM PROJECTWHERE PROJNO LIKE “MA%”ORDER BY PROJNO |

Problem 10
For projects that have a project number beginning with MA, list the project number, project ending date and a modified ending date assuming the projects will be delayed by 10 percent.
Name the column containing PRENDED, ESTIMATED. Name the derived column EXPECTED.
Order the list by project number.
Result
PROJNO ESTEMATED EXPECTED
-----------------+------------------------------------+------------------------------------
MA2100 1983-02-01 1983-03-12
MA2110 1983-02-01 1983-03-12
MA2111 1982-12-01 1983-01-03
MA2112 1982-12-01 1983-01-03
MA2113 1982-12-01 1982-12-29

ANSWER:SELECT PROJNO, PRENDATE AS ESTIMATED, PRSTDATE + ((DAYS (PRENDATE) * DAYS (PRSTDATE)) * 1.1) DAYSAS EXPECTED FROM PROJECTWHERE PROJNO LIKE “MA%”ORDER BY PROJNO |

Problem 11
How many days are between the first manned landing on the moon (July 20, 1969) and the first day of the year 2000?
Since no columns from a specific...

Show More


Citations

MLA Citation

"Case Study 2.2". Anti Essays. 10 Dec. 2018

<http://cassandralynndesignllc.com/free-essays/Case-Study-2-2-75143.html>

APA Citation

Case Study 2.2. Anti Essays. Retrieved December 10, 2018, from the World Wide Web: http://cassandralynndesignllc.com/free-essays/Case-Study-2-2-75143.html