Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write queries for 1, 2 and 3 in Relational Algebra, and write queries for 1 and 2 in Tuple Relational Calculus. PERSON PNAME, STREET, CITY)
Write queries for 1, 2 and 3 in Relational Algebra, and write queries for 1 and 2 in Tuple Relational Calculus.
PERSON PNAME, STREET, CITY) WORKS(PNAME, CNAME, SALARY) COMPANY(CNAME, CITY) PERSON gives the names and addresses of persons. WORKS gives the names of companies for which a person works together with his/her salary. COMPANY gives the cities in which each company has a branch. 1) Find the names and addresses (i.e., STREET, CITY) of all employees who work for "Facebook' 2) Find the names of all employees that work for the companies which only have branch es in Chicago 3) Find the names of all companies that have a branch in every city where "Facebook" also h as a branchStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started