Essay on Assignment2 - 613 Words

Question 1 In SQL, specify the following queries on the database specified in Figure 1 below using the concept of nested queries and the concepts described in chapter 5. a. Retrieve the names of all employees who work in the department that has the employee with the highest salary among all employees. SELECT fname, minit, lname FROM employee WHERE dno =(SELECT dno FROM employee WHERE salary= (SELECT MAX(Salary) FROM employee)); b. Retrieve the names of all employees whose supervisor’s supervisor has 888665555 for SSN. SELECT fname, minit, lname FROM employee WHERE Super_ssn IN (SELECT ssn FROM employee WHERE Super_ssn= 888665555); c. Retrieve the names of employees who make at least $10,000 more than the employee who is paid†¦show more content†¦Consultants also work on many problems at any given time. For each type of problem there is one consultant who is considered the expert on this problem. A consultant can be an expert on many different types of problems. Assuming constraints are not exact Question 4 Create an ER diagram for the following case. Write your assumptions about any missing information: You want to track information about 10 departments in your company. Each department has a unique name, is located on a specific floor and has a phone number. Within each department there is a department head and a range of additional employees. For all employees we want to track their name, who their boss is, their salary as well as the unique employee number each had assigned to them when they started the company. Each employee also has a set of skills. You need to track this set of skills so you can locate employees with the right skill set to be part of various cross department project teams. You need to also track information about all of the projects that are under taken by these various departments. Each project has a unique id, a name, a start date, and at least 3 employees on it. All teams have a project leader and a project coordinator. Any employee can be a project leader but theyShow MoreRelatedEssay on Assignment21216 Words   |  5 Pagesï » ¿Criminal Law Professor E. Dixon Assignment #2: Criminal Defenses and Criminal Punishments ABSTRACT: This paper will talk about and discuss the key points involved in the court determining the lawfulness of the use of force. I will also evaluate the level of objectivity inherent in each point that I have specified. Next, I will determine the fundamental difference between the castle doctrines and stand your ground types of criminal defenses. I will justify the validity of each,Read MoreCS669 Assignment21108 Words   |  5 Pagesï » ¿ The two parts in this assignment will contribute equally to your grade and will be evaluated separately. Part 1: Authors and Books Review the following business rules regarding authors and books to complete this part. An author writes one or more books. A book is written by one or more authors. A subject applies to at least 20 books. A book is published in a year. The business rules above specify all of the relevant entities; however, some business rules do not specify both sides of the relationshipRead MoreAssignment2 Fin100989 Words   |  4 Pages Business Finance and the Capital Structure FIN 100 Strayer University August 4, 2014 Business Financing and the Capital Structure Small business can finance their firms through debt or through equity sources of capital. Debt sources typically include; short or long-term loans from wealthy individuals to banks, while equity sources often include the owner’s wealthy individuals and/or Angel Networks. Venture capital is not a typical source of equity financing for most small businessRead MoreIBUS201 Assignment22770 Words   |  12 Pagesï » ¿ IBUS 201 Individual Assignment 2 Cover Sheet Fonterra Incident in the International Business Environment Abstract: Currently, increasing number of firms get a powerful influence by the dynamic international business environment. Fonterra 2013 incident will be analysed in order to identify the key factors of failure. Firstly, the importance of international business environment for Fonterra will be illustrated briefly. Next, the report is focus on the crucial problems and mention about clostridiumRead More2431 Assignment2 Essay7996 Words   |  32 Pagesï » ¿BEO2431 Risk Management Models ~ Semester 2, 2014 Assignment 2 Task 1 For each stock price compute and plot the return (RT) as: RT = ((Pt – Pt-1)/P t-1) Stock Prices (Weekly Data: 02/01/2006 to 30/06/2014): ASX200 = ASX200 Index WBC = Westpac ANZ = ANZ Bank BHP = BHP Billiton WOW = Woolworths TLS =Telstra 1. Comment on the volatility and volatility clustering of the returns 1) The Plot of ASX200 Return in Australia Share Market The ASX200 Return diagram demonstrates the share returnRead MoreEssay on Management Assignment22559 Words   |  11 Pagesï » ¿Executive Summary The report is based from the case study of Sir Charles Wilberforce Hospital, which aimed to investigate the major problems in leadership style, lack of communication and staff motivation. The mismatch leadership style will be solved throughout delegation Keith’s power to another supervisor in order to help encourage a more democracy leadership into the workplace. The expected outcome is to create an effective leadership style where it increase problem solving and decision makingRead MoreIntroduction To Service Blue Printing And How It Helps For Service Design Essay1844 Words   |  8 PagesOM – Assignment2 – Vimal Franklin | 1 MGT410 – Operations Management TERM III - Assignment 2 PR No: 150101619192 Date: 15 Aug’2016 Submitted by: F. B. Vimal Anand Franklin Q1. Explain service blue printing and how it helps in service design. Service Blueprinting is a method within the Service Engineering process that enables the user to have a framework for viewing service improvement. It is a visual tool that helps one see the experience a customer has with the service from a holistic viewpointRead MoreEssay about IS4560 Hacking666 Words   |  3 Pagesï » ¿ Unit2 Assignment2 Vulnerability of a Cryptosystem The vulnerability that has been discovered has a primary affect to a cryptosystem and a secondary affect to a cryptosystem. The vulnerability in question is a weakness in the MD5 algorithm that would allow for collisions in output. As a result, attackers can generate cryptographic tokens or other data that illegitimately appear to be authentic. Now the secondary affect is that the MD5 hashes may allow for certificate spoofing on a Cisco ASARead MoreAs An Efficient Organization, Cultural Enterprise Is The962 Words   |  4 Pageshttps://culturalentrepreneurs.wordpress.com/2014/10/10/a-working-definition-of-cultural-entrepreneur-3/. (Anon, 2013) Anon, (2013). Culture for Development Indicators. Available at: http://file:///Users/FionaWang/Desktop/APG5900-Cultural%20Economy/Assignment2-30%25/Reference%20Article/culture%20for%20develop%20indicators.pdf [Accessed 1 May 2017]. Cultural Enterprise Case-Disney Animation studio and Disneyland Paris â€Å"We don’t make movies to make money.We make money to make moremovies.†----Walt DisneyRead MoreJohn Locke And Thomas Hobbes Essay1490 Words   |  6 PagesThe executive branch nominates judges and the courts depend on the executive branch to enforce their own decisions. Also, the president can veto a law. The checks each branch has over the other establishes a balance of power in our government (Assignment2). Federalism is the division of power between the federal government and the states. It entails on two concepts, national and state governments sharing power, and both levels of government receiving power directly from the people (Readings Video