Write queries in relational algebra 1- Select all employees who either work in department 6 and make over 25,000 per year, or work in department 4 and make over 30,000 2- Find the Fname, Lname, and address of the employees in Dno=8

Write queries in relational algebra 1- Select all employees who either work in department 6 and make over 25,000 per year, or work in department 4 and make over 30,000 2- Find the Fname, Lname, and address of the employees in Dno=8

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Assume a database of Employees of a company have been given as shown below: Employee: Projects: Use SQL queries to find the followings: Find the average salary paid to the employees working in each project together with the project name. For each project, count the number of employees who are paid less than the average salary of that project. Find the name of the projects which have no employees assigned. Determine if there is any project with a budget less than the total salary paid to its employees. If yes, find the name of the project and its budget. The management wants to know which projects have been finished. Add an attribute to Projects table names status to show the current state of the project (Use SQL)
Write a relational algebra query/expression to show names of all faculty who work at any department that uses "Beau" building. Use the College Relational Schema provided below
QY Consider the following relations: BRANCH (branch no, street, area, city, degree, Tel_no, Fax_no) STAFF (Staff_no, Frame, Luame. address. position, salary. branch_no) Write the following queries in SQL: 1. Find all the branches that number less than 453 and found in area ‘34 east’ 2. Find staff whose salary is greater than the salary of every member of staff at branch 71 3. List all stlf who their last name ends with ‘it 4. Find allthe staff that works in branch 345 and have salary between 15000 and 45000.
How would you determine which orders have not yet been shipped to the customers? Answer must be written in SQL
Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…
Describe the circumstances in which you would choose to use embed- ded SQL rather than SQL alone or only a general-purpose programming language.
Describe the circumstances in which you would choose to use embed- ded SQL rather than SQL alone or only a general-purpose programming language.
Consider the following relations: BRANCH (branch no, street, area, city, degree, Tel_no, Fax_no) STAFF (Staff no, Fname, Lname. address, position, salary, branch_no) Write the following queries in SQL: 1. Find all the branches that number less than 453 and found in area '34 east 2. Find staff whose salary is greater than the salary of evcry member of staff at branch 71. 3. List all stalf who their last name ends with ith'. 4. Find all the staff that works in branch 345 and have salary between 15000 and 45000.
Use SQL Developer.
Write a relational algebra query/expression to show names of all faculty who work at any department that uses "Beau" building. Use the College Relational Schema provided
Using the instance of the Airport database, formulate the following queries in the relationalalgebra: 1)List the name and the state of all United States airports. 2)List full details of all airports located outside the United States.Note: You should use the not equal sign  in this query. 3)Display the number of all carriers and the average of their revenues. 4)Display the minimum, the average, and the maximum distances of the flights that arescheduled on October 17th, 2017? Example: List all airport names. π name Airport More example provided it attached file.
Use SQL and TAL Distributors database to complete the following questions:List the customer number and name for all customers located in the city of Grove. Your query should ignore case. For example, a customer with the city Grove should be included as should customers whose city is GROVE, grove, GrOvE, and so on.