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

Write expressions of relational algebra to answer the following queries:
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 book title, catalogNo and fine for all book borrowed by ‘Hussein Ali’ that has fine more than $5.
Answer the questions a and b, define the schema and also show inserting one tuple in each table.
Database Programming
Question 13 Given the following relation: Book (BookID, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: i. Read a Book id provided by user at run time and store it in a variable. ii. Fetch the Author and title of the book having the entered id and store them inside two variables iii. Display the fetched book author and title.
Question 13 Given the following relation: Movie (MovielID, Title, Genre, Year) Write a PL/SQL block of code that performs the following tasks: i Read a movie id provided by user at nun time and store it in a variable. i. Fetch the Genre and title of the movie having the entered id and store them inside two variables i Display the fetched movie Genre and title. TTTT Paragraph - Arial 3 (12pt) O f Mashups- HTHL ESS
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).
Consider a database with the following relations: Employee (Employee ID, Name, salary, startDate) Department (Department ID, Name, capacity) Project (Employee ID. Department ID, name, budget, expectedDuration) Develop the following query in SQL: Display employees (by name and salary) working on the "Engine" project and with salary higher than the average salary of all employees.
Write a relational calculus based on the following relations: Professor (ProfID, ProfName, DeptNo) Course (CrsID, CrsName, Credits, DeptNo, ProfID) Department (DeptNo, DeptName) Use domain relational calculus; 1. List all course names provided by the department named "Information Technology". 2. List all professor information who work the department named "Information Technology".
Consider the bank database of Figure 2.18. Give an expression in the relational algebra for each of the following queries: a. Find each loan number with a loan amount greater than $10000. b. Find the ID of each depositor who has an account with a balance greater than $6000. c. Find the ID of each depositor who has an account with a balance greater than $6000 at the “Uptown” branch.
Quèstion 13 Given the following relation: Movie (MovielID, Title, Genre, Year) Write a PL/SQL block of code that performs the following tasks: i. Read a movie id provided by user at run time and store it in a variable. ii. Fetch the Genre and title of the movie having the entered id and store them inside two variables ii. Display the fetched movie Genre and title. T TTArial 3 (12pt)
Consider a database with the following relations: Employee (Employee ID, Name, salary, startDate) Department (Department ID, Name, capacity) Project (Employee ID, Department ID, name, budget, expectedDuration) Develop the following query in SQL: Display projects (by name and budget) done under "Marketing" department and with budget higher 100,000$.