Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 398 Weeks Ago, 3 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Computer Science Posted 23 Sep 2017 My Price 9.00

queries in QBE.

Consider the following relational schema. An employee can work in more than one department.

Emp(eid: integer, ename: string, salary: real)

Works(eid: integer, did: integer)

Dept(did: integer, dname: string, managerid: integer, floornum: integer)

Write the following queries in QBE. Be sure to underline your variables to distinguish them from your constants.

1. Print the names of all employees who work on the 10th floor and make less than $50,000.

2. Print the names of all managers who manage three or more departments on the same floor.

3. Print the names of all managers who manage 10 or more departments on the same floor.

4. Give every employee who works in the toy department a 10 percent raise.

5. Print the names of the departments that employee Santa works in.

6. Print the names and salaries of employees who work in both the toy department and the candy department.

7. Print the names of employees who earn a salary that is either less than $10,000 or more than $100,000.

8. Print all of the attributes for employees who work in some department that employee Santa also works in.

9. Fire Santa.

10. Print the names of employees who make more than $20,000 and work in either the video department or the toy department.

11. Print the names of all employees who work on the floor(s) where Jane Dodecahedron works.

12. Print the name of each employee who earns more than the manager of the department that he or she works in.

13. Print the name of each department that has a manager whose last name is Psmith and who is neither the highest-paid nor the lowest-paid employee in the department.

Answers

Maurice Tutor
(5)
Status NEW Posted 23 Sep 2017 12:09 AM My Price 9.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll

Not Rated(0)
Relevent Questions