Query: ∏ ID, person_name (σ company_name=”BigBank” (works)) Explanation: The given query is used to find ID and name of each employee who works for BigBank in the employee database ...

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter 2, Problem 14E

a.

Explanation of Solution

Query:

∏_{ID, person_name}(σ_{company_name=”BigBank”}(works))

Explanation:

The given query is used to find ID and name of each employee who works for BigBank in the employee database...

b.

Explanation of Solution

Query:

π_{ID, person_name, city}( employee ⋈_{employee.id =works.id}( σ_{company_name = "BigBank"} ( works )) )

Explanation:

The given query is used to find ID, name and city of residence of each employee who works for BigBank in the employee database...

c.

Explanation of Solution

Query:

π_{ID, person_name, street, city}( σ_{(company_name = "BigBank"} _∧_{salary > 10000} ( works ⋈_{employee.id = works.id} employee ))

Explanation:

The given query is used to find ID, name, street address and city of residence of each employee who works for BigBank and earns more than $10000 in the employee database...

d.

Explanation of Solution

Query:

∏_{ID, person_name}

(σ_{employee.city=company.city}(employee ⋈_{employee.id=woks.id}works

⋈_{works.company_name=company.company_name}company))

Explanation:

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Consider the employee database of Figure 2.17. Give an expression in the relational algebra to express each of the following queries: a. Find the name of each employee who lives in city “Miami”. b. Find the name of each employee whose salary is greater than $100000. c. Find the name of each employee who lives in “Miami” and whose salary is greater than $100000.

Consider the bank database of Figure 2.18. Give an expression in the relational algebra for each of the following queries: a. Find the name of each branch located in “Chicago”. b. Find the ID of each borrower who has a loan in branch “Downtown”

Write the following queries in relational algebra, using the university schema.a. Find the ID and name of each instructor in the Physics department. b. Find the ID and name of each instructor in a department located in thebuilding “Watson”.c. Find the ID and name of each student who has taken at least one coursein the “Comp. Sci.” department.d. Find the ID and name of each student who has taken at least one coursesection in the year 2018.e. Find the ID and name of each student who has not taken any coursesection in the year 2018.

Answer 2

Expert Solution & Answer

Chapter 2, Problem 14E

a.

Explanation of Solution

Query:

∏_{ID, person_name}(σ_{company_name=”BigBank”}(works))

Explanation:

The given query is used to find ID and name of each employee who works for BigBank in the employee database...

b.

Explanation of Solution

Query:

π_{ID, person_name, city}( employee ⋈_{employee.id =works.id}( σ_{company_name = "BigBank"} ( works )) )

Explanation:

The given query is used to find ID, name and city of residence of each employee who works for BigBank in the employee database...

c.

Explanation of Solution

Query:

π_{ID, person_name, street, city}( σ_{(company_name = "BigBank"} _∧_{salary > 10000} ( works ⋈_{employee.id = works.id} employee ))

Explanation:

The given query is used to find ID, name, street address and city of residence of each employee who works for BigBank and earns more than $10000 in the employee database...

d.

Explanation of Solution

Query:

∏_{ID, person_name}

(σ_{employee.city=company.city}(employee ⋈_{employee.id=woks.id}works

⋈_{works.company_name=company.company_name}company))

Explanation:

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter 2, Problem 14E

a.

Explanation of Solution

Query:

∏_{ID, person_name}(σ_{company_name=”BigBank”}(works))

Explanation:

The given query is used to find ID and name of each employee who works for BigBank in the employee database...

b.

Explanation of Solution

Query:

π_{ID, person_name, city}( employee ⋈_{employee.id =works.id}( σ_{company_name = "BigBank"} ( works )) )

Explanation:

The given query is used to find ID, name and city of residence of each employee who works for BigBank in the employee database...

c.

Explanation of Solution

Query:

π_{ID, person_name, street, city}( σ_{(company_name = "BigBank"} _∧_{salary > 10000} ( works ⋈_{employee.id = works.id} employee ))

Explanation:

The given query is used to find ID, name, street address and city of residence of each employee who works for BigBank and earns more than $10000 in the employee database...

d.

Explanation of Solution

Query:

∏_{ID, person_name}

(σ_{employee.city=company.city}(employee ⋈_{employee.id=woks.id}works

⋈_{works.company_name=company.company_name}company))

Explanation:

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter 2, Problem 14E

a.

Explanation of Solution

Query:

∏_{ID, person_name}(σ_{company_name=”BigBank”}(works))

Explanation:

The given query is used to find ID and name of each employee who works for BigBank in the employee database...

b.

Explanation of Solution

Query:

π_{ID, person_name, city}( employee ⋈_{employee.id =works.id}( σ_{company_name = "BigBank"} ( works )) )

Explanation:

The given query is used to find ID, name and city of residence of each employee who works for BigBank in the employee database...

c.

Explanation of Solution

Query:

π_{ID, person_name, street, city}( σ_{(company_name = "BigBank"} _∧_{salary > 10000} ( works ⋈_{employee.id = works.id} employee ))

Explanation:

The given query is used to find ID, name, street address and city of residence of each employee who works for BigBank and earns more than $10000 in the employee database...

d.

Explanation of Solution

Query:

∏_{ID, person_name}

(σ_{employee.city=company.city}(employee ⋈_{employee.id=woks.id}works

⋈_{works.company_name=company.company_name}company))

Explanation:

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter 2, Problem 14E

a.

Explanation of Solution

Query:

∏_{ID, person_name}(σ_{company_name=”BigBank”}(works))

Explanation:

The given query is used to find ID and name of each employee who works for BigBank in the employee database...

b.

Explanation of Solution

Query:

π_{ID, person_name, city}( employee ⋈_{employee.id =works.id}( σ_{company_name = "BigBank"} ( works )) )

Explanation:

The given query is used to find ID, name and city of residence of each employee who works for BigBank in the employee database...

c.

Explanation of Solution

Query:

π_{ID, person_name, street, city}( σ_{(company_name = "BigBank"} _∧_{salary > 10000} ( works ⋈_{employee.id = works.id} employee ))

Explanation:

The given query is used to find ID, name, street address and city of residence of each employee who works for BigBank and earns more than $10000 in the employee database...

d.

Explanation of Solution

Query:

∏_{ID, person_name}

(σ_{employee.city=company.city}(employee ⋈_{employee.id=woks.id}works

⋈_{works.company_name=company.company_name}company))

Explanation:

Answer 8

Chapter 2, Problem 14E

a.

Explanation of Solution

Query:

∏_{ID, person_name}(σ_{company_name=”BigBank”}(works))

Explanation:

The given query is used to find ID and name of each employee who works for BigBank in the employee database...

Answer 9

Chapter 2, Problem 14E

a.

Explanation of Solution

Query:

∏_{ID, person_name}(σ_{company_name=”BigBank”}(works))

Explanation:

The given query is used to find ID and name of each employee who works for BigBank in the employee database...

Answer 10

b.

Explanation of Solution

Query:

π_{ID, person_name, city}( employee ⋈_{employee.id =works.id}( σ_{company_name = "BigBank"} ( works )) )

Explanation:

The given query is used to find ID, name and city of residence of each employee who works for BigBank in the employee database...

Answer 11

b.

Explanation of Solution

Query:

π_{ID, person_name, city}( employee ⋈_{employee.id =works.id}( σ_{company_name = "BigBank"} ( works )) )

Explanation:

The given query is used to find ID, name and city of residence of each employee who works for BigBank in the employee database...

Answer 12

c.

Explanation of Solution

Query:

π_{ID, person_name, street, city}( σ_{(company_name = "BigBank"} _∧_{salary > 10000} ( works ⋈_{employee.id = works.id} employee ))

Explanation:

The given query is used to find ID, name, street address and city of residence of each employee who works for BigBank and earns more than $10000 in the employee database...

Answer 13

c.

Explanation of Solution

Query:

π_{ID, person_name, street, city}( σ_{(company_name = "BigBank"} _∧_{salary > 10000} ( works ⋈_{employee.id = works.id} employee ))

Explanation:

The given query is used to find ID, name, street address and city of residence of each employee who works for BigBank and earns more than $10000 in the employee database...

Answer 14

d.

Explanation of Solution

Query:

∏_{ID, person_name}

(σ_{employee.city=company.city}(employee ⋈_{employee.id=woks.id}works

⋈_{works.company_name=company.company_name}company))

Explanation:

Answer 15

d.

Explanation of Solution

Query:

∏_{ID, person_name}

(σ_{employee.city=company.city}(employee ⋈_{employee.id=woks.id}works

⋈_{works.company_name=company.company_name}company))

Explanation:

Answer 16

Expert Solution & Answer

Answer 17

Expert Solution & Answer

Answer 18

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 19

Ch. 2 - Prob. 1PE Ch. 2 - Prob. 2PE Ch. 2 - Prob. 3PE Ch. 2 - Prob. 4PE Ch. 2 - Prob. 5PE Ch. 2 - Prob. 6PE Ch. 2 - Prob. 7PE Ch. 2 - Prob. 8PE Ch. 2 - Prob. 9PE Ch. 2 - Describe the differences in meaning between the...

Query: ∏ ID, person_name (σ company_name=”BigBank” (works)) Explanation: The given query is used to find ID and name of each employee who works for BigBank in the employee database ...

Explanation of Solution

Query: ∏ID, person_name(σcompany_name=”BigBank”(works)) Explanation: The given query is used to find ID and name of each employee who works for BigBank in the employee database...

Explanation of Solution

Query: πID, person_name, city ( employee ⋈employee.id =works.id ( σcompany_name = "BigBank" ( works )) ) Explanation: The given query is used to find ID, name and city of residence of each employee who works for BigBank in the employee database...

Explanation of Solution

Explanation of Solution

Query: ∏ID, person_name (σemployee.city=company.city(employee ⋈employee.id=woks.id works ⋈works.company_name=company.company_name company)) Explanation:

Want to see the full answer?

Chapter 2 Solutions

Query:

∏_{ID, person_name}(σ_{company_name=”BigBank”}(works))

Explanation:

The given query is used to find ID and name of each employee who works for BigBank in the employee database...

Query:

π_{ID, person_name, city}( employee ⋈_{employee.id =works.id}( σ_{company_name = "BigBank"} ( works )) )

Explanation:

The given query is used to find ID, name and city of residence of each employee who works for BigBank in the employee database...

Query:

∏_{ID, person_name}

(σ_{employee.city=company.city}(employee ⋈_{employee.id=woks.id}works

⋈_{works.company_name=company.company_name}company))

Explanation: