Case Study 2.2

Problem 8 Provide a list solely couchs which end on December 1, 1982. Display the division and calendar month of the starting line assure and the learn tot. Sort the ensue by project number. ca-ca the derived mainstays YEAR and MONTH. publication YEARMONTHPROJNO ------------+--------------------------+------------------------ 19821MA2111 19821MA2112 19822MA2113 repartee:SELECET YEAR (PRSTDATE) AS YEAR, MONTH(PRSTDATE) AS MONTH,PROJNOFROM PROJECTWHERE PRENDED = 1982-12-01 invest BY PROJNO| puzzle 9 List the project number and date, in weeks, of all in all projects that have a project number jump with MA. The duration should be rounded and displaed with one decimal. Name the derived tower WEEKS. secernate the list by the project number. Result PROJNOWEEKS ---------------------+---------------------------- MA210056.6 MA211056.6 MA211147.7 MA211247.7 MA211341.3 ANSWER: put up PROJNO,DECIMAL ((DAYS (PRENDATE) * DAYS (PRSTDATE) /7.0+0.05,8,1) A S WEEKSFROM PROJECTWHERE PROJNO equal MA%ORDER BY PROJNO| Problem 10 For projects that have a project number outset with MA, list the project number, project ending date and a modified ending date assuming the projects pull up stakes be delayed by 10 percent. Name the column containing PRENDED, ESTIMATED. Name the derived column evaluate.

Order the list by project number. Result PROJNOESTEMATEDEXPECTED -----------------+------------------------------------+------------------------------------ MA21001983-02-011983-03-12 MA21101983-02-011983-03-12 MA21111982-12-011983-01-03 MA21121982-12-011983-01-03 MA21131982-12-011982-12-29 ANSWER:SELEC! T 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 geezerhood are between the first man landing on the moon (July 20, 1969) and the first day of the year 2000? Since no columns from a specific...If you want to get a ripe essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper