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
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
Get step-by-step solutions from verified subject matter experts
