Reference no: EM13934293
Consider the following relational schema. An employee can work in more than one department; the pct time field of the Works relation shows the percentage of time that a given employee works in a given department.
Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pct time: integer) Dept(did: integer, budget: real, managerid: integer)
Write the following queries in SQL:
1. Print the names and ages of each employee who works in both the Hardware department and the Software department.
2. For each department with more than 20 full-time-equivalent employees (i.e., where the part-time and full-time employees add up to at least that many full-time employees), print the did together with the number of employees that work in that department.
3. Print the name of each employee whose salary exceeds the budget of all of the departments that he or she works in.
4. Find the managerids of managers who manage only departments with budgets greater than $1,000,000.
5. Find the enames of managers who manage the departments with the largest budget.
6. If a manager manages more than one department, he or she controls the sum of all the budgets for those departments. Find the managerids of managers who control more than $5,000,000.
7. Find the managerids of managers who control the largest amount.
|
How leadership skills develop
: Discuss and support your position on whether leaders are born or made using current research. This discussion includes the following aspects:- A brief definition of leadership and How leaders are identified.
|
|
How well do you think a general credo
: How well do you think a general credo works in guiding action? Would you prefer a typical mission statement or a clear set of policy outlines, for example? Do you see any way in which the Johnson & Johnson Credo could be improved or modified?
|
|
Retail trade and extraction of crude petroleum
: This section about DRB(Data Requirement Brief). The variable of these data collected is turnover of two sectors: Sector 52: Retail Trade and Sector 11: Extraction of Crude Petroleum. Those companies are random choose as the sample of group of reta..
|
|
Provide perspective on significance of group counseling
: Provide your perspective on the significance of group counseling. Explain how group members might benefit from their participation in group work. Explain why group work is emphasized in professional counseling literature.
|
|
Find the enames of managers who manage the departments
: Find the enames of managers who manage the departments with the largest budget. Find the managerids of managers who manage only departments with budgets greater than $1,000,000.
|
|
Provide a dsm-v diagnosis
: Provide a DSM-V diagnosis, including code, R/O, and all relevant specifiers.
|
|
Appropriate research methodologies and techniques
: Can Instant message replace e mail in the future" - Can Instant message be a primary source of internal communication? -How this instant message system will work? -What cost would be? etc...
|
|
What should lewis have done
: Of all the decisions made by Ken Lewis in this case study, which one do you think did the most damage to his reputation? Why?
|
|
Different logistics activities conducted by iaj
: a) What are IAJ's logistic requirements and how would you go about identifying them? b) What are the different logistics activities conducted by IAJ and are they being effectively employed by the company?
|