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
GraphicgID gName, gType, gLocation
DisplaywebID gID
CoursewarecID cDescription, ftpLocation, category
ftpLinkwebID 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
