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

Need help answering this pseudocode row question

Need help! Wheres the error in the pseudocode?

Where are the errors in the code? Need help.

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: