Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 1. Given the following relations (primary keys are underlined): Emp( eid : integer, ename : string, age : integer, salary : real), Works( eid

Problem 1. Given the following relations (primary keys are underlined):

Emp(eid: integer, ename: string, age: integer, salary: real),

Works(eid: integer, did: integer, pct_time: integer),

Dept(did: integer, dname: string, budget: real, managerid: integer)

Write Relational Algebra expressions for the following questions/queries.

Find employees names and eids for those who works in a dept with a budget larger than $500,000.

Find employees names and eids for those who work in at least two different departments.

Find department names and dids for those departments that have only full-time employees (If pct_time = 100%, the employee is full-time in this department)

Find departments names and dids for those that have only employees with salary larger than $40,000 there.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions

Question

What is cost plus pricing ?

Answered: 1 week ago

Question

1. What are the types of wastes that reach water bodies ?

Answered: 1 week ago

Question

Which type of soil has more ability to absorb water?

Answered: 1 week ago

Question

13-6 How will MIS help my career?

Answered: 1 week ago