Question: Expression trees: Please answer the questions in the attached photo CSC 545/745: Theory of Database Systems Homework Assignment 3 (10 points) Today's Date: Tuesday, February

Expression trees: Please answer the questions in the attached photo  Expression trees: Please answer the questions in the attached photo CSC

CSC 545/745: Theory of Database Systems Homework Assignment 3 (10 points) Today's Date: Tuesday, February 13 Due Date: Tuesday, February 20 1. Consider the schemas of relations: Product (pid, name, price, category, makerCid) Purchase (buyerlD, sellerID, store, pid) Company (cid, name, stock price, country) Person(ID, name, phone, city, state) ion trees to construct expressions in relational algebra for the following queries. Find the IDs, names and phones of people who live in Richmond, KY and bought products from American companies. Find IDs and names of people who bought American products but did not buy any French products a) b)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!