Register

DBMS Korth Edition 6 Exercise 2 Question 7 (Page No. 54)

647 views
1 votes
1 votes
Consider the relational database given below. Give an expression in the
relational algebra to express each of the following queries:
a. Find the names of all employees who live in city “Miami”.
b. Find the names of all employees whose salary is greater than \$100,000.
c. Find the names of all employees who live in “Miami” and whose
salary is greater than $100,000.

employee (person name, street, city)
works (person name, company name, salary)
company (company name, city)
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

–1 votes
–1 votes
0 answers
1
ajaysoni1924 asked Mar 23, 2019
432 views
DBMS Korth Edition 6 Exercise 2 Question 10 (Page No. 54)
Consider the advisor relation shown in Figure , with s id as the primary key of advisor. Suppose a student can have more than one advisor. Then, would s id still be a primary key of the advisor relation? If not, what should the primary key of advisor be?
Consider the advisor relation shown in Figure , with s id as the primarykey of advisor. Suppose a student can have more than one advisor. Then,would s id still be a prima...
User Avatar
Link Copied!