Question: Consider the following relation schema ( the primary keys are underlined ) . Webpage ( webID , webTitle, url, base, hits ) HttpLink ( sourceWebID

Consider the following relation schema (the primary keys are underlined).
Webpage (webID, webTitle, url, base, hits)
HttpLink (sourceWebID, targetWegID)
Graphic(gID, gName, gType, gLocation)
Display(webID, gID)
Courseware(cID, cDescription, ftpLocation, category)
ftpLink(webID, cID)
Write the following queries with relation algebra
For relation algebra solutions, you can copy and paste the following symbols as you need or use words such as selection, projection, rename, join, union, intersection, difference instead.
\sigma \pi \rho -
Which webpages (webTitle) display 'gif' or 'jpg' graphics (gif and jpgare gType )?
Which webpages (find webID) have more than 1000 hits?
Which webpages (find webTitle) does not have ftplinks?
Which webpages (find webID and webTitle) display graphics?
Which webpages (find webID) use jpg graphics, but not gif graphics?

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!