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

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

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!