2.14 Consider the employee database of Figure 2.17. Give an expression in the relational algebra to express each of the following queries: employee (person_name, street, city) works (person name, company name, salary) company (company_name, city) Figure 2.17 Employee database. A. Find the ID and name of each employee who works for "Big Bank." B. Find the ID, name, and city of residence of each employee who works for "Big Bank." C. Find the ID, name, street address, and city of residence of each employee who works for "Big Bank" and earns more than $10000. D. Find the ID and name of each employee in this database who lives in the same city as the company for which she or he works.

2.14 Consider the employee database of Figure 2.17. Give an expression in the relational algebra to express each of the following queries: employee (person_name, street, city) works (person name, company name, salary) company (company_name, city) Figure 2.17 Employee database. A. Find the ID and name of each employee who works for "Big Bank." B. Find the ID, name, and city of residence of each employee who works for "Big Bank." C. Find the ID, name, street address, and city of residence of each employee who works for "Big Bank" and earns more than $10000. D. Find the ID and name of each employee in this database who lives in the same city as the company for which she or he works.

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

Briefly explain data definition statement
Define "network security." Explain how data encryption works.
Describe the basic operations of relational algebra in simple terms.
Question 20 Please fill in the blank correctly.
For the following Relational Algebra / SQL statements, specify the output of each query. (do not explain how each query will be executed, but specify the output to be obtained when the query is executed). (c) R1: ACTORS WHERE YearOfBirth < 1940 OR Gender = 'female' R2(SSNo, FName, LName): R1 [ SSNo, FName, LName ] R3: R2 NATURAL-JOIN ACTEDIN OVER SSNo C: R3 [ LName, Character ] (d) SELECT A1.FName, A1.LName, A1.YearOfBirth FROM ACTORS A1, ACTORS A2 WHERE A1.YearOfBirth = A2.YearOfBirth AND A1.SSNo != A2.SSNo (e) R1: ACTEDIN [ FilmNo, SSNo ] R2: FILMS WHERE FilmTitle = 'Unforgiven' [ FilmNo ] R3: ACTEDIN NATURAL-JOIN R2 OVER FilmNo [ SSNo ] R4: ACTORS NATURAL-JOIN R3 OVER SSNo [ SSNo, FName, LName ] R5: ( R1.SSNo ÷ R4.SSNo ) [ FilmNo ] C: ACTEDIN NATURAL-JOIN R5 OVER FilmNo [ FilmTitle ] (f) SELECT A.FName, A.LName, COUNT(*) FROM ACTORS A, ACTEDIN AI WHERE A.SSNo = AI.SSNo GROUP BY A.SSNo, A.FName, A.LName HAVING count(*) > 2 OR count(*) = 0
After executing a Cartesian product of student and advisor, followed by a selection operation on the result with the predicate s id = ID, what is the outcome of the operation? When stated in relational algebra's symbolic notation, this query may be represented as s id=ID(student advisor).
Run the problem using Relational Algebra, below the problem I added the needed table. Use self join find the answer (4) Find the name (fname,lname) of the direct supervisor of “Mary Smith”. (“Mary Smith” is an employee). group: emplyeeemployee = {fname, lname, ssn,superssn, departnumber'Mary', 'Smith',111, 222, 11'Green', 'Marjorie',333, 222, 12'Gren', 'Cheryl',222, 777, 14}
subject : database system Member (MemberID, Name, ContactNo, Status, Sex)Borrow (BorrowNo, MemberID, CatalogNo, CheckOut, Return, Fine)Book (CatalogNo, Title, Author, Publisher, Year, Category) Write the appropriate relational algebra to produce the following queries. List member ID for members that borrowed all the ‘database’ books (category).
Please solve and show work.
Relational Algebra Questions:Using the instance of the Airport database, formulate the following queries in the relationalalgebra: 1. List full details of all airports located outside the United States.Note: You should use the not equal sign  in this query. 2. List the name and the state of all United States airports. 3. List the name and the fleet size of all carriers employing more than 50000 workers. 4. List the carrier name, the carrierID, the flightNo and the date of all flights. 5. Display the number of airports. 6. Display the number of flights with distances longer than 3000 miles. 7. Display the number of all carriers and the average of their revenues. 8. Display the number of flights leaving from JFK and the total of their distances. 9. Display the minimum, the average, and the maximum distances of the flights that arescheduled on October 17th, 2017?
explain the topic of Relational algebra Selection and Projection
Please slove and show all steps.