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 and finally sold at less than
ii Find the patent no and patent titles for all the users who sold their patents at a price
greater than
Find the output for the following:
Pi PatentNo PatentContentssigma StartBid PatentNo Pi PatentNoPatent
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
