Find maximum salary of employees from database table

Assignment Help Database Management System

Reference no: EM1364466

Q1) person(person name, street, city) // records about all people
works(person name, company name, annual salary) // records about employed people
company(company name, founded) // companies and years when they were founded
company location(company name, city) // companies and cities where they have oces
managed by(person name, manager name) // employed people and their managers

Give an expression in relational algebra for each of the following queries:

(a) Find the maximum salary of all employees who are not managers.

(b) Give all the managers in the database a 10 percent salary raise. Give all the other employees a 5 percent salary raise.

Reference no: EM1364466

Questions Cloud

Analyzing the financial performance : The ratio analysis indicates that ACME has increased their profits and decreased their liabilities from 2003 to 2004. ACME has also increased their ability to cover interest payments and increased their return on assets.

Elucidate the reasoning for your vote based on the four step : Elucidate the reasoning for your vote based on the four steps of risk assessment. Consider any relevant political, social, and economic aspects involved.

Explain how many cars does the united states export : Explain how many cars does the United States export. Suppose a car costs $10,000 on the world market. How much, then, does a barrel of oil cost on the world market.

Access database and queries : What are some of the advantages and the disadvantages of database forms? What is your experience in using Queries? Have you ever read the SQL commands generated by a Query in Access database?

Find maximum salary of employees from database table : Find the maximum salary of all employees who are not managers. Give all the managers in the database a 10 percent salary raise. Give all the other employees a 5 percent salary raise.

Determine the velocity and position of the particle : find the velocity and position of the particle asthe moment it reaches it's maximum x coordinate.

First aid-hypothermia : After several days of bitterly cold weather, you wonder how your elderly neighbor is coping with the cold, so you stop by his house. You have to ring the door several times before he answers, and when you step inside, it feels very cold inside the..

Illustrate what price should it charge : Suppose instead that the station seeks to maximize its profit from sales of the DVDs. Illustrate what price should it charge. How many DVDs should it order from which supplier.

Explain every month sam tabor is assigned : Explain Every month Sam Tabor is assigned a different job at Russo & Daughters Financial Consulting

User Account

All Pages