Week 1 Submission Essay - 1132 Words

Homework (100 points) Part 1 Create the tables from demo.sql script Download and Copy the demo.sql file from the Doc Share to the C:\temp directory. At the sql prompt enter the command @V:\temp\demo.sql. This will create some tables and insert data into them. View the script in notepad to determine the table names that were created. Use the describe command to view the structure of the tables. Please use the template below to provide your solutions. Write SQL statements to solve the following requests. Question (4 pts per question) | SQL statement or answer | 1. List all employee information in department 30. | SELECT * FROM emp WHERE deptno = 30; | 2. List employees name, job, and salary that is a manager and†¦show more content†¦Show the employee name, salary, commission, and the total of salary and commission. Be sure you evaluate null values correctly. | | 13. Write an SQL query that retrieves data from the COURSE table for courses that cost 1195, and whose descriptions do not start with ‘Intro’, sorted by their prerequisites in descending order. | SELECT COURSE_NO, DESCRIPTION, COSTFROM COURSE WHERE COST = 1195, DESCRIPTION != INTRO%, PREQUISITES DESC; | 14. Write an SQL query that retrieves data from the STUDENT table for students whose last names begin with â€Å"A† though â€Å"T† and who work for ‘Competrol Real Estate’, sorted by the last names. | SELECT * FROM st udent WHERE (WHERE last_name LIKE [A-T]) AND employer = Competrol Real Estate; | 15. Determine which student does not have the first letter the last name capitalized. Show the STUDENT_ID and LAST_NAME columns. | SELECT student_id, last_name FROM student WHERE SUBSTR( last_name, 1,1 )= SUBSTR (LOWER (last_name), 1,1) | 16. Check if any of the phone numbers in the INSTRUCTOR table have not been entered in the (###)###-#### format. Show the instructor last name and the phone number that is in the incorrect format. | Select phone, last_name from instructor where translate (phone, 0123456789,##########) lt;gt; (###)###-####; | 17. Write an SQL statement that uses the CAST function that converts a number datatype to a varchar datatype. | | 18.Show MoreRelatedCourse Activity : A Case Study Of Students1088 Words   |  5 Pageshours, then on Saturdays of 35.48 hours, last on Tuesdays of 32.25 hours. The main areas the X, Y, Z students are engaging is the Content folders, Discussio ns 1 2, and e-Activities. The highest weeks of student’s engaging in the LMS were in Week 4 and Week 5. The main areas the students did not engage were in Career insights, Week 3 and Week 6 shows they were low in Discussions, Assignments, e-Activity, and Content folders. Equally important, these students were actively using the LMS on TuesdayRead MoreOverview Of A Case Study1054 Words   |  5 Pageshours, then on Saturdays of 35.48 hours, last on Tuesdays of 32.25 hours. The main areas the X, Y, Z students are engage is the Content folders, Discussions 1 2, and e-Activities. The highest weeks of student’s engaging in the LMS were in Week 4 and Week 5. The main areas the students did not engage were in Career insights, Week 3 and Week 6 shows they were low in Discussions, Assignments, e-Activity, and Content folders. Equally important, these students was actively using the LMS on Tuesday,Read Moreis3110 project1391 Words   |  6 PagesProject Part 1 % Grade 8% Project Part 1 Task 1: Risk Assessment Plan Week 1 Week 2 4% Project Part 1 Task 2: Risk Mitigation Plan Week 1 Week 3 4% Project Part 2 Project Part 2 Task 1: Introduction and Business Impact 8% Week 3 Week 4 4% Project Part 2 Task 2: Business Continuity Plan (BCP) Week 3 Week 5 2% Project Part 2 Task 3: Computer Incident Response Week 3 Week 5 2% Week 1 Week 6 9% Analysis Plan Team (CIRT) Plan Risk Management Plan Final Submission DeliverablesRead MoreMgt 300 Module 3 Leadership and Teams891 Words   |  4 Pagesthe following two assignments to complete this week. Do not do both assignments. Identify your assignment choice in the title of your submission. Leadership and Teams – Theoretical Leadership Models Synthesize the topics of leadership and teams by crafting an essay in which, using supporting materials, you assess the theory and practice of leadership as it relates to teams. In your critical essay, address both of the following items: 1. Describe and explain how one leadership model (aRead More200336 Business Academic Skills 2011.1 Essay Instructions (50%)900 Words   |  4 Pageshas been learnt throughout the entire semester. Details Due Date: Length: Week 14 Workshop and online (Turnitin) 1200 words Based on the Learning Portfolio assessment, write a 1200 word academic essay addressing the following question. Students should include six (6) to ten (10) scholarly references which include at least three (3) of the Five Required Resources found on vUWS in the Assessment Tasks sub-folder called Week 14 - Essay, as well as any other references that may help them support theirRead MoreEssay on Acc 504965 Words   |  4 Pagesproject at the end of Week 5 and the final, completed project at the end of Week 7. Using the financial statements for Oracle Corporation and Microsoft Corporation, respectively, you will calculate and compare the financial ratios listed further down this document for the fiscal year ending 2011 and prepare your comments about the two companies’ performance based on your ratio calculations. The entire project will be graded by the instructor at the end of the final submission in Week 7, and one gradeRead MoreComparative Analysis of Kohl and J.Cpenny Essay9 09 Words   |  4 Pagesend of Week 5 and the final completed Project at the end of Week 7. Using the financial statements for Kohl’s Corporation and J.C. Penney Corporation, respectively, you will calculate and compare the financial ratios listed further down this document for the fiscal year ending 2010 and prepare your comments about the liquidity, solvency and profitability of the two companies based on your ratio calculations. The entire project will be graded by the instructor at the end of the final submission in weekRead MoreSupply and Demand and Academic Honesty Policy Essay1057 Words   |  5 PagesGE273: Project PROJECT DESCRIPTION This project has three parts, namely Part 1, Part 2, and Part 3. Project Part 1 Introduction: Different economic studies estimate the price elasticity of demand for certain goods, some of which are reported on page 176 of the Hubbard/O’Brien textbook. The following table presents select elasticity of demand estimates from those reported on page 176. Product Barnes Noble books Coca-Cola Cigarettes Beer Gasoline -4.00 -1.22 -0.25 -0.23 -0.06 Estimated Elasticity Read MoreCourse: Financial Ratios and Ratio1201 Words   |  5 Pagesend of Week 5 and the final completed Project at the end of Week 7. Using the financial statements for Oracle Corporation  and Microsoft Corporation, respectively, you will calculate and compare the financial ratios listed further down this document for the fiscal year ending 2011 and prepare your comments about the liquidity, solvency and profitability of the two companies based on your ratio calculations. The entire project will be graded by the i nstructor at the end of the final submission in weekRead MoreProject Management Models973 Words   |  4 PagesExercise 4 1. Hamilton Country Parks is planning to develop a new park and recreational area on a recently purchased 100-acre tract. Project development activities include cleaning playground and picnic areas, constructing road, constructing a shelter house, purchasing picnic equipment, and so on. The PERT/CPM network shown below is being used in the planning, scheduling, and controlling of this project. D 2 A 9 1 6 3 4 H 6 C E 0 I 6 7 3 Activity time in weeks B 6 3