Question: Consider the following Schema: User ( UserId , Name, Password ) Patent ( PatentNo , PatentTitle, PatentContents, Diagrams, UserId ( Foreign Key ) ) Bid

Consider the following Schema:
User (UserId, Name, Password)
Patent (PatentNo, PatentTitle, PatentContents, Diagrams, UserId (Foreign Key))
Bid (BidNo, UserId (Foreign Key), PatentNo (Foreign Key), StartBid, FinalSellingPrice)
Give an expression in the relational algebra to express each of the following queries:
i) Find all the bids that started at a price greater than 3000 and finally sold at less than
15,000.
ii) Find the patent no. and patent titles for all the users who sold their patents at a price
greater than 2000.
Find the output for the following:
\Pi (PatentNo, PatentContents)(\sigma (StartBid >3000^ PatentNo =(\Pi PatentNo(Patent)))
Bid)
Write a sentence describing what the query will return.
Example: All patent holders whose names are John.

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 Programming Questions!