Question: please help me do these questions of database Problems 1. (3 points) Consider the following relations, R,S and T. Show the results of the following

please help me do these questions of database
Problems 1. (3 points) Consider the following relations, R,S and T. Show the results of the following queries: a) M1b(T) b) M2RS c) M3RS d) M4ST e) M5SS.a=T.bS.a>cT f) M6ST 2. ( 1+1 points) Consider the following relations: product (pid, pname, price, makercid) purchase (buyerID, pid) company (cid, cname, country) person (ID, name, phone) Write the following queries in relational algebra: a) Find the buyerID of people who did not purchase any product with a price greater than 200. b) Find the pid of those product that are made in USA or were purchased by Tom Smith
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
